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