Automatically highlight fields with dates that are older than 5 business days?

[lvcourtney]

I have columns of dates and I'm looking to automatically highlight dates that are older than 5 business days from today. Is that conditional formatting? Thanks in advance​

 

[TheCman81]

Set up conditional formatting with formula and use

=NETWORKDAYS(A1,TODAY())>5

 

[JoeMo]

I have columns of dates and I'm looking to automatically highlight dates that are older than 5 business days from today. Is that conditional formatting? Thanks in advance​

You can use conditional formatting based on a formula using the WORKDAY function. Example for Dates in A1:A100:
Select A1:A100, then use this formula to set the condition:

=$A1<workday(today(),-5)< html=""> < </workday(today(),-5)<>WORKDAY(TODAY(),-5)

Then set the format you want.

 

[lvcourtney]

You can use conditional formatting based on a formula using the WORKDAY function. Example for Dates in A1:A100:
Select A1:A100, then use this formula to set the condition:

=$A1<WORKDAY(TODAY(),-5)< html=""> < </WORKDAY(TODAY(),-5)<>WORKDAY(TODAY(),-5)

Then set the format you want.

Thank you!!