DayOfYear Function?

[Joe]

Is there anyway to return the day number of the year. For example, where
12/26/2003 would be = to 300.

 

[Ole Michelsen]

If you try with 1 in a cell and then format that cell to date, then you will
get day number 1. Count the number of days from that day until the day from
which you want to start and subtract that number from int(now()).

Ole

 

[Dan E]

Joe,

This should work, say your date was in A1

=DATEDIF("2003/1/1",A1,"D") + 1

Dan E

 

[Dianne]

Is there anyway to return the day number of the year. For example,
where 12/26/2003 would be = to 300.

With a simple formula, you could do something like this, assuming 12/26/2003
was in A1:

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

 

[Jake Marx]

Hi Joe,

This function should do that:

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

 

[Bob Phillips]

Worksheet solution in response to your .misc query.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dana DeLouis]

If it's a programming solution you need, two possibilities could be:

Function DayOfYear(dte As Date) As Long
DayOfYear = dte - DateSerial(Year(dte), 1, 0)
' or...
DayOfYear = Format(dte, "y")
End Function

The second idea appears to be a "hair" faster, besides shorter.