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
|