Skip to main content
Web Applications

Return to Question

deleted 17 characters in body; edited title
Source Link
serenesat
serenesat
  • 10k
  • 30
  • 33
  • 50

Increasing the value of a cell in google sheetGoogle 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 iei.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. Thanks in advance.

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 ie 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. Thanks in advance.

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.

Source Link
S R Sharma
S R Sharma
  • 1

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 ie 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. Thanks in advance.