Hi all.
I'm doing a budget sheet at home and want to update next due date baded on IF todays date has passed, change the due date to the following month with same day.
Example. Would be. today is the 03/10/19 I have a due date " 04/10/19 " . i want this to change to 04/11/19 automatically once todays date is greater or has passed this due date.
and then Same again with november changing to December and so forth. I can get it towork using "date(year(),month()+1,day())" but this only works for the first time and nothing after.
Any help would be great.
Thanks
Adrian
Bookmarks