PC Review


Reply
Thread Tools Rate Thread

How to add 7days to today’s date

 
 
Tradex
Guest
Posts: n/a
 
      9th Jun 2008
i would like to make an automatic date seven days from todays date. is the
formula available or should i manually edit it.

thank you for you help everyone
 
Reply With Quote
 
 
 
 
Doug Robbins - Word MVP
Guest
Posts: n/a
 
      9th Jun 2008
See fellow MVP Macropod's Date Calc 'tutorial', at:

http://www.wopr.com/cgi-bin/w3t/show...?Number=249902


--
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

"Tradex" <(E-Mail Removed)> wrote in message
news:9AD41107-D46C-4D1B-96FB-(E-Mail Removed)...
>i would like to make an automatic date seven days from todays date. is the
> formula available or should i manually edit it.
>
> thank you for you help everyone



 
Reply With Quote
 
Jules
Guest
Posts: n/a
 
      9th Jun 2008
Tradex, you could use a macro - set a bookmark where you require date to be
inserted and save document as template:

Sub Tester1 ()

Selection.GoTo What:=wdGoToBookmark, Name:="Date"
Selection.InsertBefore Format((Date + 7), "d MMMM yyyy")

End Sub

Distributing macros to other users
http://www.word.mvps.org/FAQs/Macros...buteMacros.htm

"How to create global event procedures similar to AutoOpen, AutoNew and
AutoClose, without using Normal.dot"
http://www.word.mvps.org/FAQs/Macros...AutoMacros.htm

"Running a macro automatically when a document is created, opened or closed"
http://www.word.mvps.org/FAQs/Macros...mentEvents.htm


"Tradex" <(E-Mail Removed)> wrote in message
news:9AD41107-D46C-4D1B-96FB-(E-Mail Removed)...
>i would like to make an automatic date seven days from todays date. is the
> formula available or should i manually edit it.
>
> thank you for you help everyone



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MONEY at your doorstep within 7days!! malik Microsoft Access Database Table Design 0 19th Feb 2004 03:04 AM
MONEY at your doorstep within 7days!! malik Microsoft Access Form Coding 0 19th Feb 2004 03:04 AM
MONEY at your doorstep within 7days!! malik Microsoft Access VBA Modules 0 19th Feb 2004 02:59 AM
MONEY at your doorstep within 7days!! malik Microsoft Access External Data 0 19th Feb 2004 02:59 AM
MONEY at your doorstep within 7days!! malik Microsoft Access Security 0 19th Feb 2004 02:59 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:22 PM.