Forum Discussion

dcsgard's avatar
dcsgard
Copper Contributor
Dec 31, 2022

Formula for Next Month

I am using an old spreadsheet for my budget I have used for years and I have lost some of the formulas.

I had a check box in one of the cells that if I clicked on it it would show me my balances for "next month".

I also had a second one that would show 2 months down the road if both were checked. 

Any idea what I would use as a formula to put those back in my spreadsheet?

Formulas and Functions

3 Replies

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Dec 31, 2022
    It's difficult to draw up a formula without knowing the arrangement of the data in your workbook. It might help if you're able to upload or link (OneDrive, Dropbox, etc.) to an anonymized copy of the workbook.
    • dcsgard's avatar
      dcsgard
      Copper Contributor
      Jan 01, 2023
      https://www.dropbox.com/scl/fi/ym2ep1x2lree3q4kpt4ay/Test-Budget-Sheet-for-Formula.xlsx?dl=0&rlkey=3itoqt3it58yw9o5fhg3x1pr1
    • dcsgard's avatar
      dcsgard
      Copper Contributor
      Jan 01, 2023
      Ok thank you let me try to do that. It’s been awhile since I’ve used any of those apps.
      Would Google docs work for you?