Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updates | Excel Discussion (Misc queries) | |||
How do I convert a serial number to the month, day, and year in E. | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
How do I get the COUNTIF criteria to recognize only month and yea. | Excel Worksheet Functions | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |