Tired of counting this on my fingers....

[Rhett]

...Is there a better way? What will tell me what day of the year a specific date is? For example, if I want to know that January 15, 2023 is the 15th day of the year, how do I make Excel tell me?
Thank you!

 

[Aladin Akyurek]

=A1-DATE(YEAR(A1),1,1)+1

Format the formula cell as General.

 

[Mark W.]

="1/15/2023"-"1/2023"+1

Or, for a date value in cell A1...

=A1-TEXT(A1,"m-yyyy")+1
This message was edited by Mark W. on 2002-09-20 08:08

 

[Rhett]

Thank you - that worked perfectly!