Date formula question

[Geekoftheweek2019]

I need to make a formula that takes the current date and adds years and months to the time for an "date of expected completion.

Example

Lets say I am trying to save $1,000.(B14)
I can save $2 a day. (B15)
I can save $14 a week (B16)
I can save $56 a month (B17)
I can save $672 per year (B18)

Now I need a formula that can determine the date of reaching $1,000 assuming that I can save exactly $2 every day starting from today’s date. (B20)

If anyone can help I would be very happy

[Cookievore]

Hello, there is already an error in the line of thought in your example. First you claim 7 days a week but later you presume static 28 days per month which is wrong. A year has 365 (or even 366 days) but you calculate it to 336 days, therefore your “save per year” is wrong (also per month)!

The formula is target value / daily save = days it would need. 2nd current date + days it would need = target date. Put that into a calc sheet and you’ll have a solution.