Formula based on Single Select Field question

#1

Hi Everyone,

I’m trying to set up a field that calculates the length of service of our volunteers based on a single select box with options Active/Inactive. The formula is returning the correct info for active volunteers, but for the Inactive option the cell remains blank. How do I get it to return results for both options?

IF({Active/Inactive}=“Active”,DATETIME_DIFF(TODAY(),{Start Date},‘days’,IF({Active/Inactive}=“Inactive”,DATETIME_DIFF({End Date},{Start Date},‘days’))))

#2