How to add 7days to today’s date

  • Thread starter Thread starter Tradex
  • Start date Start date
T

Tradex

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
 
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/MacrosVBA/DistributeMacros.htm

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top