start/end dates of a week given just the weeknum() value
Maybe this..........
With your weeknumber in A1,
This in B1
=TEXT(38353+(A1*7)-7,"mm/dd/yy")
This in C1
=TEXT(38353+(A1*7)-1,"mm/dd/yy")
Vaya con Dios,
Chuck, CABGx3
"David" wrote:
Hi
I see weeknum() can return a week number given a date.
However I need to reverse this procedure and calculate the START and END
dates for a week given just the weeknumber [weeknum() ] for the week
concerned
for example, given
week number 50 I need to return Dec 5 (start) and Dec 11 (end)
week number 51 I need to return Dec 12 (start) and Dec 18 (end)
thanks , David
|