How to combine two formulas

Corin

I have an Aging column (start date-Today) and once my Health Status G/Y/R/C column= C, I need the aging to stop. What formula would I use for this?

Jason Duryea

If the Health Status is "C" you would need to base the formula on a non-variable date like Finish Date. For example:

=IF([Health Status]@row = C, [Start Date]@row - [Finish Date]@row, [Start Date]@row - Today)

Jason Duryea

If the Health Status is "C" you would need to base the formula on a non-variable date like Finish Date. For example:

=IF([Health Status]@row = C, [Start Date]@row - [Finish Date]@row, [Start Date]@row - Today)