day of year

[Sharon]

In excell 2003, how do I create a formula that will give me the number of day
of the year? Today (April 5) is the 95th day of the year. Thank you.

 

[JE McGimpsey]

One way:

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