User Submitted Macro

Get Next Day

Written by Steve Kunkel, DHL Express Netherlands BV

What it does

This macro will calculate the date of the next day starting with any day you choose.

To install

Download the file umgetnextday.mex and save it to your hard drive where you store your macro file(s). Open this macro file or import the macros into your existing macro file by clicking File, Import, Import Macros.

To use

The macro ‘Get Next Day’ is designed to be called from another macro using the Macro Run command. Put the starting day in variable T3, the starting month in T4 and the starting year in T5. Use the Macro Run command to run the ‘Get Next Day’ macro. The variable T1 will contain the resulting date in DD/MM/YY format, T2 will contain the resulting date in MM/DD/YY format, T3 will contain the new day, T4 the new month and T5 the new year.

The macro ‘Use Get Next Day macro’ demonstrates how this works. Run ‘Use Get Next Day macro’ to watch it run and then edit it to see how it works.


– Macro Express 3

** Steve Kunkel wins a Macro Express T-shirt for this submission.