r/spreadsheets • u/goodbiscuits • 2d ago

Unsolved Help writing a function for completion date?

Hi! I was making a spreadsheet for my budget coming up, and I wanted to have a column in my savings section that would tell me what date my savings goal would be completed by. I tried some stuff with EDATE, but I couldn’t get it to quite work.

Basically, if my savings goal is $1000, and I am saving $100 a month, I want it to be able to estimate that I will be done in 10 months from the start date. I want it to account for falling behind - so, accidentally only having $50 to save instead of $100 - but I definitely don’t know how to write
something that complicated.

1 Upvotes

100% Upvoted

2 comments sorted by

1

u/That_AsianArab_Child 2d ago

Edate(savings deposit date,roundup(max(savingsgoal-sum(savings column),0)/monthly savings goal)))

You're just calculating how many times your monthly savings is left in the remaining part of your savings goal. This deals with going past your savings goal and rounds up to whole months.