Changing "Today" referance in a formula to a cell referance

**ianmb** · 05-02-2011, 08:47 AM

With the help of other forum members I have managed to arrive at the formulas to do the aging of invoices. Attached is the sample workbook.

Now I am trying to change the today formula in the 30+ days etc to read from the Date cell. The reason I want to do this so that when I save the individual statement and I reopen it again, it does not calculate everything again with the “TODAY” date.

I have tried doing this by removing today and replacing it with the cell number “G4” but it is giving me an error all the time. How can this be done?

**NBVC** · 05-02-2011, 08:58 AM

I don't understand.

You replace all the A2 references in cells B2:E2 with G4 and got errors?

**ianmb** · 05-02-2011, 09:47 AM

No, I am changing the "TODAY" in Formula A44 : E44 with Cell G4 and getting an error.

**ChemistB** · 05-02-2011, 10:18 AM

Make sure your Options on your Find/Replace window are set to "Look in Formulas" and you want to Replace TODAY() not just TODAY. I just did it with your spreadsheet with no errors.