ExcelBanter - How to use year function?

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

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

- - How to use year function? (https://www.excelbanter.com/excel-discussion-misc-queries/120694-re-how-use-year-function.html)

Teethless mama

How to use year function?

Check your system clock to make sure you have the right Date/Time

"Eric" wrote:

Does anyone know why =year(today()) =6/28/05, rather than 1/30/2006?
Thank you for any suggestion
Eric Choi

All times are GMT +1. The time now is 07:19 PM.