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?
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.