View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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