Automatically showing the day of the year

[maiestia]

For some stuff I do at work I need to know the day (not date) of the year. eg today the 28th of july is day 210 of the year.


However, I haven't yet found a way to get excel to this for me automatically, and have to check my diary each time I open this particular spreadsheet and manually enter the day.


Does anyone know how to get excel to work this out automatically?

 

[Wing-Nuts]

How about using:


=TODAY()-"01/01/2009"

 

[maiestia]

when I stick that into excel I get "26/07/1900"...

 

[govi]

Check this link:

http://spreadsheetpage.com/index.php/tip/calculate_the_day_of_the_year_and_days_remaining/

 

[Wing-Nuts]

You just need to change the format of that cell to "General", that should give you 208.

 

[maiestia]

"How about using:


=TODAY()-"01/01/2009" "


This gives me the day of the year one day out (According to my diary, i think the example i game in the first post was wrong.)


The link posted by govi gave me the answer, but instead of having it refer to the date in another cell i altered it to only refer to today:


=today()-DATE(YEAR(today()),1,0)


It appears to work beautifully now. thanks for your help everyone!