Formating Week numbers into week range

[maic15]

I have a week number of 45, which is equal to 10/31/05 - 11/04/05. ( Business days, from Monday - Friday).

How do I translate 45 into the following string in my cell "10/31/05 - 11/04/05"?

 

[Artemus]

The following formula will return a text string of "10/31/05 - 11/06/05" if you enter the number 45 in cell A1. This is based on using serial date number 38348 (12/27/04) as the starting point for counting weeks.


=TEXT(38348+(A1-1)*7,"mm/dd/yy")&" - "&TEXT(38348+(A1-1)*7+4,"mm/dd/yy")

 

[Artemus]

Typo, sorry. The formula is correct the displayed text shows the wrong results. The formula results should be "10/31/05 - 11/04/05".

 

[maic15]

thanks!