Converting date to day number

[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.

 

[Ian]

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

 

[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

 

[Niek Otten]

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

 

[Chris]

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

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