Column W is formatted as shown below (initials & date):
AC–8 Aug 14
MN-14 Jul 14
MC-2 Aug 14
I would like to apply conditional formatting to the cells in Column W based on the following criteria:
Cell background = red if today's date is > 5 working days than date string in Column W cell
Below is my attempt, but it doesn't factor in working days, and more to the point, doesn't work:
If you need any further information, just let me know...