Excel - Automatic date changer

Kieran Grant 0 Reputation points
2024-09-26T09:57:18.4766667+00:00

Hi

I'm trying to have one date that changes once that date is reached, adding 4 weeks to it.

example:

starting with the cell displaying 18 Oct 24

when it actually gets to that date, the cell adding 4 weeks to it, displaying 15 Nov 24

this action happening automatically

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,883 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,892 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Barry Schwarz 2,901 Reputation points
    2024-09-27T19:13:03.2466667+00:00

    You can write a macro that will execute whenever you open the workbook. The macro can check the cell's value against today's date and take the appropriate action.

    See https://trumpexcel.com/vba-events/ for information on event driven macros.

    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.