changin date dd/mm/yy into Month

J

Jo

I am trying to summarise dates from 01/04/09 to April. Can any body help.
I have tried = month(cell) , but it comes up with a value . Any ideas?
 
O

Otto Moehrbach

If you have a date in say, A1, and you want to show the month in B1, in B1
enter "=A1" without the quotes. Now format B1 as custom mmmm. HTH Otto
 
G

Gord Dibben

Might be your date is not a date, but text.

What happens when you try to format it?


Gord Dibben MS Excel MVP
 

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

separating date and time 5
Month (MMM) from date (dd/mmm/yy) 1
time_report_date-wise_employee-wise 6
VBA - exporting serial letters to single documents 0
Date format in Excel 2007 mm/dd/yy not appearing correctly 2
Formulea 4
Add numbers with a DATE as one of the conditions 5
Extract Month and year from Cell containing date, month, year & time 2

Top