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

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"kurt" wrote in message
...
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

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


"kurt" wrote in message
...
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

If you prefer text, use

=TEXT(A1,"mmmm")

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Anne Troy" wrote in message
news:d3c6e$42c5a397$97c5108d$15062@allthenewsgroup s.com...
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


"kurt" wrote in message
...
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

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

"kurt" wrote:

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