How to retrieve the first date and last date of each week in a month from a monthly calender?
I need to display the date like
w1-01/08/2012 - 04/08/2012
w2- 05/08/2012 - 12/08/2012
similarly foe week3 , 4 5
Thanks in advance..
Pls anyone help me .
How to retrieve the first date and last date of each week in a month from a monthly calender?
I need to display the date like
w1-01/08/2012 - 04/08/2012
w2- 05/08/2012 - 12/08/2012
similarly foe week3 , 4 5
Thanks in advance..
Pls anyone help me .
You need to have a starting date, for instance cell A1 = 01/08/2012 then end of the week in B1 is A1+6. Start of the following week in A2 = B1+1 etc.
Pl see the attached file.
If it is OK mark the thread solved.
@ bongaan and kvsrinivasamoorthy.. Thanks a ton for this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks