Converting date to day number

C

Chris

I want to have two columns:
the first with date;
the second with the corresponding day number.

How do I do that?

I don't care what the day numbers are - as long as they are sequential.
 
P

Peo Sjoblom

That would be days since Jan 0 1900, I am not sure the OP wanted that

=DAY(A1)

will return the day of the month

=A1-DATE(2005,1,1)+1

will return the day of the year

format as general
 
N

Niek Otten

=Weekday(A1) will return the day of the week, which was my interpretation of
the question!
 
C

Chris

Excel already stores dates as sequential numbers. Assuming your date is
in A1, in B1 type =A1 and format as General.
Click to expand...

Thanks, Ian - that's exactly what I wanted.
Much obliged.
 
Top