Thread: Day of year
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default Day of year
And following that
=TODAY()-DATE(YEAR(TODAY()),1,0)
Should work in any year.

HTH
Martin


Reply With QuoteReply With Quote