i know with vba you can get the name of the month by

monthname(month(date)) ' will give you the present month
' date being the equivalent of Today()
' or replace date by the value in your cell


hth

J


"Dave M." wrote:

I have two cells containing dates in the format of 07/14/05. I can use
Selection.NumberFormat = "m/yy;@" to change the format of the cells to month
and year. However, Excel still uses the original serial number from
07/14/05. I am trying to compare these two cells and delete any transactions
that did not take place in the same month, but until I figure this out I can
only capture the transactions in the same day. Does anyone have any
suggestions?