| 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 | |||
Linear Mode
