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

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

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



--
Regards
Dave Hawley
www.ozgrid.com
"NDBC" wrote in message
...
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

Hi

=A1-DATE(YEAR(A1),1,0)
--
Regards
Roger Govier

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