ExcelBanter - day of year

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - day of year (https://www.excelbanter.com/excel-discussion-misc-queries/81640-day-year.html)

Sharon

day of year

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

day of year

One way:

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

In article ,
Sharon wrote:

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.

All times are GMT +1. The time now is 09:59 PM.