Thread: Day of year
View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 46
Default Day of year

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