LiSa

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

Gord Dibben Excel MVP


On Sat, 12 Jun 2004 11:51:40 -0700, "LiSa"
wrote:

I have a cell in a spreadsheet with Today() in it which
returns the current system date. Is there a way of adding
a month on to this. I know about the DateAdd function in
VBA, but would rather use a cell formula if possible.

TIA