dates
Thanks that works great, but I still have to reference the
cell D1 with =Today() in it.
Is there any way I can have it all in one cell?
-----Original Message-----
one way
=DATE(YEAR(D1),MONTH(D1)+1,DAY(D1))
--
Don Guillett
SalesAid Software
"LiSa" wrote in
message
...
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
.
|