Using VBA makes quick work of entering dates into the future or past into a Microsoft Word document. Here’s how to use it.
Illustration: Lisa Hornung, Getty Images/iStockPhoto
The article How to easily include dynamic dates in a Word doc using Excel suggests calculating dates in Excel and using mail merge to a Word template when you need to calculate dates for a Microsoft Word document. The reason? Word’s DATE field isn’t flexible, so when you need more than DATE provides, the Excel route is a good choice. However, if you need only to add or subtract a specific number of days, you can use a VBA procedure instead. In this article, I’ll show you how to use VBA to insert static dates a specific number of days into the future or past.
SEE: 83 Excel tips every user should master (TechRepublic)
I’m using Microsoft 365 on…