Forum Discussion

Pasco2018's avatar
Pasco2018
Copper Contributor
Mar 04, 2020

Aging report formula that does NOT use 'TODAY' but rather March 6 2020

Hello, I have created a 13 week aging report for a 13 week cash flow.  I am currently using =IF(AND(TODAY()-$C486<=21,TODAY()-$C486>14),$D486,0) formula, does anyone know a formula that can be used f...
Formulas and Functions
ChrisMendoza's avatar
ChrisMendoza
Iron Contributor
Mar 04, 2020

Pasco2018 -

If I understand correctly, I offer two options:

Option1 uses a helper field:

=IF(AND($A$2-D2<=21,$A$2-D2>14),TRUE,FALSE)

Option2 does not:

=IF(AND(DATEVALUE("3/6/2020")-D2<=21,DATEVALUE("3/6/2020")-D2>14),TRUE,FALSE)

 

Resources