Thread
:
Excel should support DAYOFYEAR(year,month,day) returns julian dat.
View Single Post
#
1
Neil
Posts: n/a
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
Reply With Quote