Thread: Day of year
View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Day of year

Exactly! That's what I was trying to get across.

"MartinW" wrote:

Hi JLatham,

It will work as a generic what is the Julian date, but only for the current
year. Excel takes care of the Leap Years.

Where it will fall down is if you want to know the Julian Date of future or
previous years, such as what is the Julian date for 2nd May 2003 etc.

Regards
MartinW