0

I have the starting value of a cell (say A1) as 100 on Jan 1st.

Every month, for a period of 12 months, I need to see the value in A1 increase by 100 i.e. on Feb 1st, March 1st, April 1st...Dec 1st, A1 should read as 200, 300, 400.. with the final value of 1,200 on Dec 1st.

I'd be grateful for any answers, am stumped.

Improve this question
3
  • Welcome. Please see how to How to Ask and edit your question. Also please read how to and share a test sheet so as you can be easier helped.
    – marikamitsos
    Commented Jul 24, 2022 at 9:25
  • Still interested in an answer? Please share what you have tried so far.
    – marikamitsos
    Commented Jul 24, 2022 at 9:37
  • Here is a hind. Use a combination of these Google Sheets functions: EOMONTH, TODAY and MONTH.
    – marikamitsos
    Commented Jul 24, 2022 at 9:46

1 Answer 1

Reset to default
1

In A1:

=(DATEDIF("01/01/2022",TODAY(),"m")+1)*100

Replace the date (in quotes) with your start date and 100 with your amount that will serve as both the initial amount and the increment.

If you want a more accounting-accurate version:

=FV(0,DATEDIF("01/01/2022",TODAY(),"m"),-100,-100)

FV is Future Value (of an investment). Here, 0 is the interest rate, DATEDIF will figure out how many complete months have passed as marked from the date in quotes, the first -100 is the payment amount (which, in accounting, is always negative), and the second -100 is the initial value contributed on the start date. Using this method would allow you to set different values for the initial value and the monthly increase thereafter.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.