• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automatically showing the day of the year

maiestia

New Member
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?
 

govi

Member
Check this link:

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

maiestia

New Member
"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!
 
Top