Date formula question

asked 2019-05-25 22:23:15 +0200

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 :)

edit retag flag offensive close merge delete

Comments

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.

Cookievore gravatar imageCookievore ( 2019-05-26 08:25:13 +0200 )edit