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

    Number of days excluding friday

    Gopinathan L

      Hi,

       

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

      For Ex,

      1.

      Date1 : 01-Jun-2014

      Date2 : 10-Jun-2014

       

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

       

      2.

      Date1 : 01-Jun-2014

      Date2 : 20-Jun-2014

       

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

       

      Thanks in Advance.