Insert Month and Year in my worksheet
 

How do I write the formula for the following.

The current Month & 2004. Ex: November (2004)

I want the month and year to change when a new month happens.

Myrna
--
Thank you

Enter this formula in the cell:

=TODAY()

THEN, custom format the cell to:

mmmm (yyyy)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Myrna" wrote in message
...
How do I write the formula for the following.

The current Month & 2004. Ex: November (2004)

I want the month and year to change when a new month happens.

Myrna
--
Thank you