I have a table that is tracking multiple savings goals, when they are due, and how much I have to save to reach my goal. I want to add a fourth column that tells me how many months I have left before the due date, so I can include a fifth column that will calculate how much I have to save per month to reach my goal by the due date.
This is my data:
GOAL DUE $ LEFT MO LEFT SAVE PER MO 500 FEB 2021 350 FORMULA =C2/D2 200 DEC 2020 175 FORMULA =C3/D3 300 APR 2021 200 FORMULA =C4/D4 300 APR 2021 200 FORMULA =C4/D4 300 APR 2021 200 FORMULA =C4/D4 300 APR 2021 200 FORMULA =C4/D4
TODAY 10/02/20
What formula can I put into Column D that will calculate time in months from today until the due date in column B?
Bookmarks