If the dates are in, say column A, then in a helper column enter:
=DATE(2007,5,DAY(A1)) and copy down.

If you can't use a helper column, then in an un-used cell enter 30.
Copy that cell and paste/special/add onto the April dates. Then change the
format back to date.

--
Gary''s Student - gsnu200714