Conditional Formatting

[mattbird]

Hi,

I have set up a conditional format in cell G6 that turns the cell red if the date in the cell is greater than 20 day from that date. but I want it to only count working days Mon-Fri and not weekends ie

Referral date (cell G6) 16 Jan 18 the cell turns red after 20 days being 5 Feb 18, but this counts the weekends. without the weekends being counted it should turn red on 13 Feb 18.

Is there away of Excel doing this? If so please can someone help me.

I am currently using Excel 2010

Thanks Matt

 

[njimack]

=NETWORKDAYS(G6,TODAY())>=20

Of if you have a list of public holidays...

=NETWORKDAYS(G6,TODAY(),Holidays)>=20

 

[mattbird]

Thanks, works perfectly