Workday function

[Snowy1]

Hi

Have input the folloing conditioning format in cell B4 and have used the TODAY function.

=TODAY()-A4>30

What i want is exactly the same but to count working days.

I want cell B4 to go red 30 working days after the date input in A4.

Can anyone assist?

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Joe4]

If your value is in cell A1, use this Conditional Formatting Condition in cell B1:

=OR(AND(B1="",WORKDAY(A1,30)<=TODAY()),WORKDAY(A1,30)<=B1)

 

[Snowy1]

This formula works - the only issue is B1 shows red even if a date is not entered in A1.
Is there a way that B1 remains blank until a date is entered in A1 and then the formula then starts?

Thanks

 

[Joe4]

Try:

=OR(AND(A1<>"",B1="",WORKDAY(A1,30)<=TODAY()),AND(A1<>"",WORKDAY(A1,30)<=B1))