How do I automatically add certain dates in Excel when a cell is updated? Is there any way to do so, and keep the previous dates in the cell as well, like a list?

hkop 0 Reputation points
2024-08-26T15:48:16.6133333+00:00

In Excel, is there any way to automatically add a set of upcoming dates when a cell is updated? Lets say when I change the number in a cell from a 0 to a 1, is there any way to add the dates for the upcoming weekend in a different cell? Then, if I change it from a 1 to a 2, 2 to a 3, 3 to a 4, so on and so forth, is there a way to just add the dates in the cell like a list instead of the previous dates just being replaced by the new ones?

If I change it from a 0 to a 1 this week, how can I make it so it adds the dates for this upcoming weekend. Then if I change the 1 to a 2 sometime next week, how can I make it so the cell that has the date from the previous weekend, keeps that previous set of dates, and adds the dates from the upcoming weekend, so on and so forth.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,808 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,833 questions
{count} votes

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.