View Single Post
  #1   Report Post  
Neil
 
Posts: n/a
Default Excel should support DAYOFYEAR(year,month,day) returns julian dat.

And the reverse function JULDATE. This is easier than writing the equation:
=DATE(2005,4,15)-DATE(2005,1,1)+1