Hi
try
=DATE(YEAR(A1),MONTH(A1)+1,MIN(DAY(A1),DAY(DATE(YE AR(A1),MONTH(A1)+2,0)
)))

--
Regards
Frank Kabel
Frankfurt, Germany


libby wrote:
A while ago someone posted asking how to add a month onto
todays post.
However it wasn't done in code, but by a formula in a cell.

Does anyone know how to do this?
ie a formula which will display todays date + 1 month.

Thankies