So simple, yet I can not seem to get this right. I need month/year only in one cell. Thanks.
G Ginny Jan 26, 2005 #1 So simple, yet I can not seem to get this right. I need month/year only in one cell. Thanks.
I IC Jan 26, 2005 #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
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
