PDA

View Full Version : [SOLVED] Work Week dates from Week Numbers



oam
11-10-2013, 03:40 PM
I would like to know how to get the first and last Work Day in date format from each WEEK NUMBER, example shown below:



Work Week Number

48

49

50



Work Week start -Week End

11/25/2013 -11/29/2013

12/2/2013 - 12/6/2013

12/9/2013 - 12/13/2013

Bob Phillips
11-11-2013, 02:40 AM
Try this formula

=TEXT(DATE(YEAR(TODAY()),1,1)-WEEKDAY(DATE(YEAR(TODAY()),1,1))+1+(_weeknum-1)*7+1,"mm/dd/yyyy")&" - "&TEXT(DATE(YEAR(TODAY()),1,1)-WEEKDAY(DATE(YEAR(TODAY()),1,1))+1+(_weeknum-1)*7+5,"mm/dd/yyyy")

_weeknum is a named cell that contains the work week number

oam
11-11-2013, 07:35 AM
Thank you so much, it worked perfectly!