locked
To get the list of working days-3 to working days+10 of every month RRS feed

  • Question

  • Hi,

    I am looking for a query,which will give me the list of working days in a column (except Saturday and Sunday)ranging from
    [Working day- 3] to [Working day +10]of each month from (April 2014 ) till 2016 December.Could you please help me in achiving it.

    Note :Working day -3 means ,When the first working day of a month is [ 1st April ,Monday].
    So it has to result as March 27,28 and 29 as my last working days.
    Same logic applies for Working day +10(it needs to give total 10 dates,which excludes Saturday and Sunday)

    Regards,

    Ramesh

    Wednesday, April 2, 2014 5:42 AM

All replies