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,875 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,882 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Barry Schwarz 2,826 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

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.