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

Hi,

The standard Excel formula do that


For week number
=WEEKNUM(C2,2)

For day number
=WEEKDAY(C2,2)

Mike

"Jonno" wrote:

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

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

Hi mike,

Thanks for replying but that wasnt what i wanted.
--
Jonno


"Mike H" wrote:

Hi,

The standard Excel formula do that


For week number
=WEEKNUM(C2,2)

For day number
=WEEKDAY(C2,2)

Mike

"Jonno" wrote:

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

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

.