View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
DAiuto DAiuto is offline
external usenet poster
 
Posts: 2
Default I want a the to display the Month name only. Nothing else.

I have a formula the following formula =EDATE(A3,1) that gives me a result of
"May-07" because the cell is formatted as:
Catagory = Date
Type = Mar-01
But I don't want the year to display, just the month. Any idea how I can do
that?

Thank you,
DAIUTO