5 Replies Latest reply: Jun 3, 2014 3:13 AM by Rajendra Nagargoje RSS

    Number of days excluding friday

    Gopinathan L



      I need to calculate the number of days between the two dates excluding the Fridays.

      For Ex,


      Date1 : 01-Jun-2014

      Date2 : 10-Jun-2014


      No .of days =9, because 6th Jun 2014 is Friday



      Date1 : 01-Jun-2014

      Date2 : 20-Jun-2014


      No .of days =17, because 6th,13th and 20th Jun 2014 are Fridays.


      Thanks in Advance.