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

Originally Posted by xld

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

Thread: First date in week from <WeekNo, Year>

Thread Tools

Display

First date in week from <WeekNo, Year>

Posting Permissions