New Help on If/AND to amortize contract revenue

Lisa Burgess

Below are my cells and formula which keeps returning INVALID:

Paul Newcome

Remove the opening parenthesis before [Engagement Terminates] and one of the closing parenthesis from the end. That should clear it up for you.

Lisa Burgess

Paul,

Removing the parenthesis did not work, however, changing the criteria to the "DATE(2020,12,1) format you mentioned in your other post worked!

Thanks Paul!!

Paul Newcome

Happy to help! 👍️

As long as your summary fields are set to be a date type field, then referencing that SHOULD have worked instead of having to use the DATE function as your criteria. That's the whole point of referencing fields like that so you have dynamic data instead of having to manually update a formula every so often...