Thanks for the feedback, Randy
I'm glad "=EOMONTH(A1,0)+1" worked for you.

--
Regards,
Ron


"Randy" wrote:

Worked great thanks...........