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.
|