Prev: Hyperlink in footer
Next: Link Pivot Tables on one filter
From: NDBC on 12 May 2010 01:17
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
From: Jacob Skaria on 12 May 2010 01:29
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
From: ozgrid.com on 12 May 2010 03:22
=A1-DATE(YEAR(A1)-1,12,31) and Format as General.



--
Regards
Dave Hawley
www.ozgrid.com
"NDBC" <NDBC(a)discussions.microsoft.com> wrote in message
news:448493D0-C012-4427-B616-68A824572640(a)microsoft.com...
>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

From: Roger Govier on 12 May 2010 04:11
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
 | 
Pages: 1
Prev: Hyperlink in footer
Next: Link Pivot Tables on one filter