View Full Version : First date in week from <WeekNo, Year>
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?
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.
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))
Thanks Mikey Just what I was looking for
:o)
BBM
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.