Day of the Year

[SPORTS96]

I need a cell that will show the day of the year.

Example - Today would be 108

That is the number of days so far this year.

And also have it update automatically.

Thanks

[oldchippy]

Use this,

=TODAY() then Custom format the cell to dddd mmm, this will change every day

[SPORTS96]

That shows like this

Wednesday Apr

I want


108

[oldchippy]

Try this, and format cell to General

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

or this

=TODAY()-DATE(YEAR(TODAY()),1,1)+1 to include today?

[SPORTS96]

Perfect

Thanks

[oldchippy]

Glad it worked for you - thanks for the feedback