hi Dylan
You can use this
=DATE(YEAR(A1),MONTH(A1)+1,1)
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Dylan @ UAFC" wrote in message ...
in
A B
1/19/2088 2/1/2008
2/20/2008 3/1/2008
1/23/2008 2/1/2008
What formula can I use in the B column to make this
happen