Insert an auto update future date in Visio Pro

Mark Foster 0 Reputation points
2023-02-09T13:17:10.78+00:00

I can't figure out how to create a text box in Visio Pro that takes the day the file is opened, adds 25 years and displays the result. Note: I consider myself an "average/beginner" user of Visio Pro.

Microsoft 365 and Office | Visio | For business | Windows
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2023-02-10T08:19:16.9166667+00:00

    Hi @Mark Foster,

    You can enter the Field in the Text with the Custom Formula:

    =DATE(YEAR(NOW())+25,MONTH(NOW()),DAY(NOW()))

    User's image

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.