Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Terry Kinnard Terry Kinnard is offline
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Steve Yandl[_3_] Steve Yandl[_3_] is offline
external usenet poster
 
Posts: 11
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Steve Yandl[_3_] Steve Yandl[_3_] is offline
external usenet poster
 
Posts: 11
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 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   Report Post  
Margaret9121 Margaret9121 is offline
Junior Member
 
Posts: 19
Default

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

Posting Rules

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Just the year as date format Henk57[_18_] Formatting Long Documents 1 May 28th 07 06:10 PM
Inserting Date - Year Format Only Eduardo Microsoft Word Help 1 February 10th 07 12:29 AM
Calculate Age in table from Date of Birth and Current Date (MSWord Bill Tables 6 February 17th 06 05:11 PM
Calculate a date from days date KS Microsoft Word Help 2 May 10th 05 12:50 PM
Previous Year in a Date Field Jamie Microsoft Word Help 4 April 1st 05 10:17 PM


All times are GMT +1. The time now is 02:36 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"