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)

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

"help me" wrote in message
...
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)

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

"help me" wrote in message
...
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)

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)



"help me" wrote in message
...
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)