# Increasing the value of a cell in Google Sheet every (say) 30 days

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.

• 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. Jul 24 at 9:25
• Still interested in an answer? Please share what you have tried so far. Jul 24 at 9:37
• Here is a hind. Use a combination of these Google Sheets functions: `EOMONTH`, `TODAY` and `MONTH`. Jul 24 at 9:46

`=(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.
`=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.