Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I want to calculate a date 1 year ahead of a date in a bookmark
I want to be able to calculate a new date 1 year ahead of a date that is
stored or entered in a bookmark so that if the value under the bookm ark changes the calculated date value will also change. In Excel I can easily do date calculation but if it's available in Word help is NO help. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I want to calculate a date 1 year ahead of a date in a bookmark
Terry,
See if something like this would work. Sub DateReCalc() Dim strOldDate As String Dim dteNewDate As Date strOldDate = ActiveDocument.Bookmarks("origDate").Range.Text dteNewDate = DateAdd("yyyy", 1, DateValue(strOldDate)) MsgBox dteNewDate End Sub Steve Yandl "Terry Kinnard" wrote in message ... I want to be able to calculate a new date 1 year ahead of a date that is stored or entered in a bookmark so that if the value under the bookm ark changes the calculated date value will also change. In Excel I can easily do date calculation but if it's available in Word help is NO help. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I want to calculate a date 1 year ahead of a date in a bookmark
Terry,
See if something like this would work. Sub DateReCalc() Dim strOldDate As String Dim dteNewDate As Date strOldDate = ActiveDocument.Bookmarks("origDate").Range.Text dteNewDate = DateAdd("yyyy", 1, DateValue(strOldDate)) MsgBox dteNewDate End Sub Steve Yandl "Terry Kinnard" wrote in message ... I want to be able to calculate a new date 1 year ahead of a date that is stored or entered in a bookmark so that if the value under the bookm ark changes the calculated date value will also change. In Excel I can easily do date calculation but if it's available in Word help is NO help. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I want to calculate a date 1 year ahead of a date in a bookmark
See fellow MVP Macropots Word Date Calculation Tutorial at:
http://lounge.windowssecrets.com/ind...owtopic=249902 Or http://www.gmayor.com/downloads.htm#Third_party -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Terry Kinnard" wrote in message ... I want to be able to calculate a new date 1 year ahead of a date that is stored or entered in a bookmark so that if the value under the bookm ark changes the calculated date value will also change. In Excel I can easily do date calculation but if it's available in Word help is NO help. |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I want to calculate a date 1 year ahead of a date in a bookmark
See fellow MVP Macropots Word Date Calculation Tutorial at:
http://lounge.windowssecrets.com/ind...owtopic=249902 Or http://www.gmayor.com/downloads.htm#Third_party -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Terry Kinnard" wrote in message ... I want to be able to calculate a new date 1 year ahead of a date that is stored or entered in a bookmark so that if the value under the bookm ark changes the calculated date value will also change. In Excel I can easily do date calculation but if it's available in Word help is NO help. |
#6
|
|||
|
|||
This is where indoor amplified antennas come in.Indoor amplified antennas are a popular and affordable solution for receiving free over-the-air television broadcasts. These antennas are designed to be placed indoors and connect directly to your television, allowing you to receive local channels and a variety of other programming without the need for a cable or satellite subscription. https://righttvantenna.com/
|
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Just the year as date format | Formatting Long Documents | |||
Inserting Date - Year Format Only | Microsoft Word Help | |||
Calculate Age in table from Date of Birth and Current Date (MSWord | Tables | |||
Calculate a date from days date | Microsoft Word Help | |||
Previous Year in a Date Field | Microsoft Word Help |