ExcelBanter - Formula to calculate the current year

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to calculate the current year (https://www.excelbanter.com/excel-discussion-misc-queries/145000-formula-calculate-current-year.html)

mda19652

Formula to calculate the current year

I want to calculate the current year in a cell.

David Biddulph[_2_]

Formula to calculate the current year

=year(today())
--
David Biddulph

"mda19652" wrote in message
...
I want to calculate the current year in a cell.

All times are GMT +1. The time now is 10:11 PM.