Thread
:
dates
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
dates
Gord forgot to include the day.
=DATE(YEAR(A1),MONTH(A1)+1,1)
=DATE(YEAR(A1),MONTH(A1)+1,day(a1))
--
Don Guillett
SalesAid Software
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]