I want a the to display the Month name only. Nothing else.

G

Guest

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
 
G

Guest

Is that all? I'm going in the other room to laugh at myself... sorry for
bothering all of you. : )
 
G

Gord Dibben

Not a bother and you should see the number of rooms I've had to go into<g>


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Current Month with real date 2
Convert Text to Date Month and Year 1
Location Oriented Formula 1
Access Getting Month periods to show in ACCESS query as 0 when there is no data for the month 0
Calculating occupational sick pay entitlement 0
(month) 2 digits in formula 5
Adding months to date at end of month 4
Dates - Need to display date one month prior to user-entered date 13

Top