Number of the day of the year

[NDBC]

I need a formula that will look at a date and tell me what number day it is
in that year. eg 31/1/2007 would show as 31. 1/3/2008 is 61. It is sort of
like a julian date but without the year part of the number.

Thanks

 

[Jacob Skaria]

Try the below with date in cell A1

=DATEDIF(DATE(YEAR(A1),1,0),A1,"d")

 

[ozgrid.com]

=A1-DATE(YEAR(A1)-1,12,31) and Format as General.

 

[Roger Govier]

Hi

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