View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dianne Dianne is offline
external usenet poster
 
Posts: 107
Default DayOfYear Function?

Joe wrote:
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

--
Dianne