=DATE(YEAR(a1),MONTH(a1)+1,1)

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Randy" wrote in message
oups.com...
I have a cell where I put a date A1. I need a formula where it will
produce the first date of the next month.


Thanks for any help.