converting dates into numbers

[help me]

converting a given date to its respective day of the year, by this i mean

January 31st is, day 31 of the year
feb 01 is , day 32 of the year
feb 02 is , day 33 of the year

I would like to enter any given date into one column and the next column to
calculate the day in a number only (1-365 days in a year)

 

[Paul B]

Here is one way, with date in A1, put this in a cell and format as general

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[JulieD]

Hi

if the dates you've entered include years you can use the following formula

=A1-(DATE(YEAR(A1),1,1)-1)

format the cell to a number or general after entering.

Cheers
JulieD

 

[Peo Sjoblom]

One way

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

format as general since it will probably default to a date

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)