| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Date
So simple, yet I can not seem to get this right. I need month/year only in
one cell. Thanks. |
|
#2
|
|||
|
|||
|
If you mean to only display month/year of a full date, then custom format
the cell to mm/yyyy to display 01/2005. If you mean you need to extract and display only the month/year from a full dat ein another cell then use =MONTH(A1)&"/"&YEAR(A1) for give 1/2005. Ian "Ginny" wrote in message ... So simple, yet I can not seem to get this right. I need month/year only in one cell. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Hybrid Mode
