Forum Discussion
Display number for time benchmarks.
I have individuals that have different start dates. What is the best way to display when they have reached 30 days, 60 days and 90 days in a cell?
Part of the answer to "best way"--to the extent you're asking with regard to the way it looks, the aesthetics, is totally up to you. But in terms of a formula, something like this:
=IFERROR(IFS((TODAY()-$C5)>=90,90,(TODAY()-$C5)>=60,60,(TODAY()-$C5)>=30,30),"Probation")
results in a screen looking like this.
You can also use Conditional Formatting to highlight anybody with fewer than 30 days in red, between 30 and 60 in yellow, between 60 and 90 in green, and above 90 just plain old "clear."
In other words, the answer to "best way" depends on what is best for your purposes.
Part of the answer to "best way"--to the extent you're asking with regard to the way it looks, the aesthetics, is totally up to you. But in terms of a formula, something like this:
=IFERROR(IFS((TODAY()-$C5)>=90,90,(TODAY()-$C5)>=60,60,(TODAY()-$C5)>=30,30),"Probation")
results in a screen looking like this.
You can also use Conditional Formatting to highlight anybody with fewer than 30 days in red, between 30 and 60 in yellow, between 60 and 90 in green, and above 90 just plain old "clear."
In other words, the answer to "best way" depends on what is best for your purposes.
- Thank you. Perfect!
