Thread: Is there a formula which returns the current (updating) year?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default Is there a formula which returns the current (updating) year?
=YEAR(TODAY())

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"George Parrog" <George wrote in message
...
I am trying to write a formula which shows the difference in years between
the present year and a date in another cell.

Reply With QuoteReply With Quote