Try the below with date in cell A1

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

--
Jacob (MVP - Excel)


"NDBC" wrote:

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