Determine Week Start Date From Year And Number

Hey All,

So once again I need some help from the Excel Gurus. I'm wanting to determine the starting date of a week. Each week will need to always start on a Monday in this example.

I want to derive the week starting date from two cells namely:
A cell that contains a number between 1 -52 (Represent week numbers)
The next cell will contain years e.g. 2013, 2014, 2015, 2016, etc.

How can I determine the week start date by CONCATENATING these two fields to return a date?

Thanks again :-).

IF A2=week No and B2= Year in C2 Put This To get date

Please Login or Register  to view this content.

Monday to Sunday is one week.

Thanks

Originally Posted by daddylonglegs

If you are using ISO week numbers whereby week 1 starts on the first Monday on or after 29th December then you can find the date with a tweak to Olly's suggestion, i.e.

=DATE(myYear,1,7*myWeek-2)-WEEKDAY(DATE(myYear,1,3))

I just wanted to clarify what you meant by on 29 December. Does this mean is I use your tweak, that week one will start from 29 December of the previous year, provided 29 December is a Monday?

Would this also be true if the Monday is on 30 / 31 December of the previous year?

Thanks to everyone for their help here. The formula really helped me solve my problem. For an additional reference, if someone wants to use this formula and then return the week number from the result set you would then use

Formula:

Please Login or Register  to view this content.