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)