Conditional Formatting for the next 7 work days

[Greg J]

Hi
I have a list of days (1 Jan 2017 to 31 Dec 2017) in column A starting at A5. I would like a formula to use in conditional formatting to highlight the next 7 work days from the current date. I need 2 formulas ? One that will exclude weekends and another that will exclude weekends and public holidays for Australia if possible please?
Thanks.
Regards, Greg

[Kaper]

Hi,
You could use conditional formatting with a rule based on formula (so CF - New rule - Use formula ...)
select A5:A369 and paste formula (weekends excluded only):

Please Login or Register  to view this content.

write down a list of public holidays (I tried to complete but in Australia you get some teritory regulations, so may be I got somewhere wrong, also I "moved" australia day to 16th, to show some difference also today) for instance in H2:H14 and refer to it in NETWORKDAYS function. So next conditional formatting (still all days selected) would be:

Please Login or Register  to view this content.

See attached file

[Greg J]

Thank you very much Kaper. That is exactly what I was after.

Also thanks for the attached spreadsheet. That explained the method perfectly.

Regards, Greg

[newdoverman]

Here are slightly different formulae. One is including today and the other not including today. Holidays and weekends are included in M1:M15 as supplied by a search for holidays in Adelaide.
Go to Conditional Formatting, New Rule, Use formula... and enter this formula and choose formatting to suit.
Not including today:

Please Login or Register  to view this content.

Including today:

Please Login or Register  to view this content.