Day of year
Huh?
<bg
JLatham wrote:
Yes, as long as both dates are in same year, but if one date was after Feb 29
of a leap year and other year is not leap year...
"MartinW" wrote:
And following that
=TODAY()-DATE(YEAR(TODAY()),1,0)
Should work in any year.
HTH
Martin
--
Dave Peterson
|