PDA

View Full Version : First date in week from <WeekNo, Year>



BBM
10-01-2009, 02:39 AM
Does anybody know how to calculate the first day in a given week number for a given year?

Thanks
BBM

Bob Phillips
10-01-2009, 03:13 AM
What week number type, ISO or MS?

BBM
10-01-2009, 03:36 AM
What week number type, ISO or MS?

Ah didnt realise there was a difference.
Better stick with ISO :)

Bob Phillips
10-01-2009, 04:19 AM
It depends upon how the week number is calculated as to which you should stick to.

BBM
10-02-2009, 07:43 AM
Ok ... how would I do this if it were ISO?

Mikey
10-04-2009, 03:49 PM
Formula solution.....

with year in A2 and ISO week number in B2 this formula gives the date of the first day (Monday) of that week

=DATE(A2,1,B2*7-2)-WEEKDAY(DATE(A2,1,3))

BBM
10-05-2009, 03:13 AM
Thanks Mikey Just what I was looking for

:o)
BBM