So juts test the month and year of the date, formatting only changes the
value seen, not the underlying value.

--
HTH

Bob Phillips

"Dave M." <Dave wrote in message
...
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?