Hi Ron De Bruin,
Thank you very much this works perfect now.
--
Jonno
"Ron de Bruin" wrote:
See
http://www.rondebruin.nl/weeknumber.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Jonno" wrote in message
...
I have a work sheet with a list of dates from todays date till one year
from
now. This is automatically updated everyday and i input week numbers into
A1
and it will state in A2 the date of the begining of that week.
I want week one to start at the first monday of the new year, not on the
1st
day of the year like below.
I want week 53 to last untill the sunday 3rd and then on the monday 4th
week
one to start.
Week Day No Date
53 1 28/12/2009
53 2 29/12/2009
53 3 30/12/2009
53 4 31/12/2009
1 5 01/01/2010
1 6 02/01/2010
1 7 03/01/2010
2 1 04/01/2010
is this at all possible?
--
Jonno
.