=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
--
David Biddulph

"dar" wrote in message
...
i have a monthly work sheet where i use days through out the month ex.

04/01/2007
04/12/2007
04/15/2007 etc.

when april is over and I want to change the month only how to I change
from
04 to 05?