Thread: Date
View Single Post
  #2   Report Post  
IC
 
Posts: n/a
Default

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.