Conditional Formatting excluding weekends

[tanky]

Hi

I'd like to track the status of reports when they are due.

When the meetings have taken place, the reports/minutes need to be drafted by 5 working days and completed by 15 working days from the date of the meeting

So currently I have in excel:

A1 B1 C1
Date of meeting Date Report Drafted Date Report Completed

I would like to use conditional formating so that when the date is entered to the B1 cell and it is more than 5 working days (exclude weekends - Sat and Sun) then the cell would flag up red. If the draft is completed before 5 working days from the meeting then green.

Any help will be grateful

 

[PawPawGary]

The following two formulas in conditional formating will give you the results you want

Condition 1
=NETWORKDAYS(A1,B1)>5

Condition 2
=AND(NETWORKDAYS(A1,B1)>0,NETWORKDAYS(A1,B1)<6)

Hope this helps,
Gary