How to use year function?
 

Thank you for your reply
I have checked the system's clock, and it is 30 Nov, 2006.
=year(today()) = 2006, but when I change the format for this cell to see
the date, then it shows 28-Jun, 2005.
Do you have any idea on this problem?
Thank you very much
Eric

"Teethless mama" wrote:


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