Current year/month

[burugudug]

is there a formula in excel where you can display the current year/month in a certain cell?
and will automatically be updated when the year/month changes.

thanks

[burugudug]

sorry about that, i already edited my first post

[burugudug]

cant seem to use
=DATE(YEAR,MONTH,DAY)
or
=YEAR

is there any other formula available?

[shg]

=TODAY() and format as you like