Insert Month and Year in my worksheet

M

Myrna

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
 
R

Ragdyer

Enter this formula in the cell:

=TODAY()

THEN, custom format the cell to:

mmmm (yyyy)
 
Top