Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

# Display number for time benchmarks.

Copper Contributor

# 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?

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Display number for time benchmarks.

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.

# Re: Display number for time benchmarks.

Thank you. Perfect!
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Display number for time benchmarks.

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.