How do I extract just the month

[kurt]

Hi out there,

I'm reading in a group of tables that have Jun-2005, Jul-2005, etc and I
want to locate the table that matches the current month. I have in cell A1
the today() function and I format the cell to be in mmm-yyyy.

but the format only changes the cells appearance not the actual value. it
still 6/30/2005 and the tables are 6/1/2005, 7/1/2005 etc.

So everytime i use IF() or write VBA I can't get it to work.

Thanks for anyhelp!!!

Regards, Kurt

 

[Anne Troy]

=Month(A1) should get you the month value.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Anne Troy]

By the way, =Month(a1) will return the NUMBER of the month. January = 1,
February = 2, etc.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Niek Otten]

If you prefer text, use

=TEXT(A1,"mmmm")

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

 

[bj]

try
=eomonth(today(),-1)+1
this will give you the first day of the current month