7 Replies Latest reply: May 7, 2013 5:03 AM by Prashant Adhav RSS

    REMOVE 2nd and 3rd Saturdays and Sundays.

      Hi to All,

       

        Need help into this,

       

      Got 2 dates viz. REC_DATE, DEP_DATE

      TAT= DEP_DATE - REC_DATE

       

      Suppose the REC_DATE is 1 Dec'11 and DEP_DATE is 13 Dec'11

       

      while calculating i have to remove 2nd and 3rd saturday and also all sundays.

       

      Please  share some hints on the same.

       

       

      Have used NETWORKDAYS bt tht remove all weekends..

       

       

      Thanks to All for considering my Querry....

       

      Prashant A.