deriving a week beginning date from the week number.

[merlin777]

I have a cell with the date of the first day of week one (european).

I need to display the date of the first day of a week number i.e. I have a cell with a week number from 1 to 53 and I want to display the date of the monday of that week in the cell below.

I'm having a problem with the ends of the year. e.g. this year's monday of week 1 (week 1 of 2014) was on Monday 30th December 2013. All the formulas I have come across either require manual entry of the year (I need automatic) or don't seem to be able to account for week 1 starting in the previous year.

This is proving a bit trickier than I expected...

 

[Michael M]

I'm betting in any / all calculations with EXcel Week one will be Monday 5th of Jan

Have a read here, Chip does everything there is to do with dates

Week Numbers In Excel

 

[merlin777]

Thanks for that. In reading the material i've realised there are so many ways to calculate it that i'm not sure which one to use in this case...

Does anyone know how the National Health Service calculates it's week numbers?