Forum Discussion
Excel Budgeting
I am sure someone has asked this before but I can't seem to find a direct answer. So here goes.
I would like to have a formula in excel to auto update a "date" within a cell based on "today's date" by increasing the month value.
For instance.
| Bill 1 | 100.00 | 10/12/2024 |
I would like excel to know that in the cell with date "10/12/2024" todays date is 11/11/2024 and then change 10/12/2024 to 11/12/2024.
If you use EDATE, you can add a month:
=EDATE(c2, 1)
