Hi all,
I need help on this. Say if i have this date 1/19/13 and time 20:00,
How do i create formula to find out the workweek my data fall in, if my WW1 range is from 1/3/13 19:00 to 1/10/13 19:00, WW2 range is from 1/10/13 19:01 to 1/17/13 19:00 and so on?
WW Date Time
1 1/3/2013 19:00
2 1/10/2013 19:00
3 1/17/2013 19:00
4 1/24/2013 19:00
5 1/31/2013 19:00
6 2/7/2013 19:00
Using simple Weeknum formula cant do it.
I need to be able to lookup at my table and find out the particular workweek for 1year data. Appreciate someone can help
Bookmarks