Changing formula to account only for working days

[AdeleR]

Hi
First time poster.
I am trying to create a formula where if more than 2 working days have passed since the date in the cell (A2), and the cell (K2) is empty, that the cell (K2) would turn red.

I think I have a formula that is working for "if 2 days have passed" but this is counting weekend days as well and not just Monday-Friday:

=AND(A2<TODAY()-2, ISBLANK(K2)

Can anybody help?
Thanks

 

[Fluff]

Hi & welcome to MrExcel.
How about

=AND(K2="",NETWORKDAYS(A2,TODAY())>2)

 

[AdeleR]

Hi & welcome to MrExcel.
How about

=AND(K2="",NETWORKDAYS(A2,TODAY())>2)

Thank you so much, this has worked for me! Thanks!

 

[Fluff]

You're welcome & thanks for the feedback.