How to use funtion to have the current year?

[plainme]

We can use today() to get today, like 04/01/2011. Now, I only want to use a function to get 2011. And, it will turn 2012 when next year comes.

Can anyone here help me?

Thanks!

 

[shg]

=year(today()) gives the current year.

 

[T. Valko]

We can use today() to get today, like 04/01/2011. Now, I only want to use a function to get 2011. And, it will turn 2012 when next year comes.

Can anyone here help me?

Thanks!

Here's another one...

=YEAR(NOW())

 

[plainme]

Thanks. I actually did both but it showed 7/3/1905. But I just checked the value is equal to 2011 which is what I need.

 

[Peter_SSs]

.. but it showed 7/3/1905.

You just need to format the cell as 'Number'

 

[T. Valko]

Thanks. I actually did both but it showed 7/3/1905. But I just checked the value is equal to 2011 which is what I need.

Format the cell with the formula as General or Number (0 decimal places).