Date
Try this:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)+2)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"robzrob" wrote in message
ups.com...
Hello All
New to this, so this question may have been answered before - don't
know.
I want to be able to add one calendar month and then 2 days to any
date. Any ideas?
Thanks
R
|