I’m organizing a list of companies and trying to calculate how many years they’ve been in business.
Some companies are still open/in existence, and some businesses have closed/shut down.
Ideally I’d like to have 3 fields:
- Start Date: The year the company opened for business
- End Date: The year the company closed for business (if the business actually closed down)
- Age: How many years the company has existed either up to today OR to the “End Date” if there is a value placed in that field.
I’m trying to figure out how to write a formula that basically states the following:
Age = IF End Date is null (TODAY - Start Date), ELSE (End Date - Start Date).
I’d also like to figure out how to make all 3 of those fields on show “years” as appose to the whole date field (month/day/year). Any guidance is much appropriated!