5 Replies Latest reply on Dec 19, 2016 11:20 AM by Shinichiro Murakami

    Help required on No. of days calculation

    Srinija Jakkula

      Hi All,

       

      My requirement is to show the no. of days by calculating the difference between start and end date after excluding saturdays and sundays that fall between those 2 dates.

      For Ex: If start date and end date are same then No. of days should be 1, else the difference between start and end date excluding saturday and sunday.

      Below is the desired result we are expecting:

      As per the above screenshot, I need a calculation to show 19 days difference between 28-Nov & 22-dec after excluding Saturday and Sundays. But my current dashboard is showing 23 days (which is actual difference).

      Thanks in advance...