Week Number Format

J

Jonno

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?
 
M

Mike H

Hi,

The standard Excel formula do that


For week number
=WEEKNUM(C2,2)

For day number
=WEEKDAY(C2,2)

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
SUMIF Formula Help 8
2010-01-04 is equal to week 2??? 1
group of dates 1
macro help 1
Check if a date comes before/after a range of dates 0
Date issues 1
Find then highlight in yellow 6

Top