Software

Ask something
Discussion Locked

Custom Date

0 helpful
7 replies

by davidross

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way to have a Word or Excel document display a future date based on the current date...say you want the date in the document to reflect a future date (5 working days from today)?

7 replies

by dklippert

Go to Tools>Add-Ins and make sure that the Analysis Toolpak is checked.
You can now use the Workday function.
To make it very cool, create a list of holidays somewhere in the workbook. Select the list abd go to Insert>Name Define and name the Range something like OurHolidays.
The formula should look like this:

=WORKDAY(NOW(),5,OurHolidays)

Format the cell as a date.

by kees.valkenswaard

In Word either use an Excel table with the formula described in answer 2 above for Excel, with only one cell shown, or use a link to a cell in Excel.
Realize, however, that the Excel methods described would always yield 5 working days after today. Thus if you open this document over a week it would again show five working days later. Just as date inserted as a field [the check box ticked] would do.
If you really want to have 5 working days after you prepared the document a macro would be required which will put the correct date in place.
Good luck.

This discussion is closed to new replies.