days since 1/1/current year
=today()-date(year(today()),1,0)
The 0th day of January of this year is Dec 31 of the previous year.
dan wrote:
Is there a formular for days since 1/1/current year
like =weekday(today()) ' day of the week
=DAY(today()) ' day of the month
=today() ' days since 1/1/1900
--
Dave Peterson
|