Macro to Calculate Date 18 months from today

[pamelamik]

I need a macro that will calculate the date 18 months from today i
COBRA letters. Does anyone know how to accomplish this? Thank you i
advance for your help

 

[Stefan Blom]

Here's an example:

Sub AddDateMonthsLater()
Dim x As String
x = Format$(DateAdd("m", 18, Now()), "mmm d yyyy")
MsgBox x
End Sub

Of course, the code needs adjusting to what you actually want to do with the
result...

--
Stefan Blom
Microsoft Word MVP




"pamelamik" wrote in message