Reply
 
Thread Tools Display Modes
  #1   Report Post  
pamelamik pamelamik is offline
Junior Member
 
Posts: 0
Default Macro to Calculate Date 18 months from today

I need a macro that will calculate the date 18 months from today in COBRA letters. Does anyone know how to accomplish this? Thank you in advance for your help.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Stefan Blom[_3_] Stefan Blom[_3_] is offline
external usenet poster
 
Posts: 6,897
Default Macro to Calculate Date 18 months from today

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 news
I need a macro that will calculate the date 18 months from today in
COBRA letters. Does anyone know how to accomplish this? Thank you in
advance for your help.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA macro - Mailmerge date - for today and for history Arden Mailmerge 6 December 1st 09 08:17 PM
macro to calculate a date in the future v&sr4JC Microsoft Word Help 12 February 6th 09 04:49 AM
Word 2002: Macro w/today's date - update date automatically MTKathy Microsoft Word Help 1 March 13th 08 11:50 PM
In Word 2002 can I calculate a future date (Today + 7 days) ketilla Microsoft Word Help 3 May 16th 06 07:02 AM
Can I calculate a merged date field based on today plus # of days Lorraine Tables 5 March 30th 06 09:52 PM


All times are GMT +1. The time now is 02:45 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"