Hi! I am hoping someone may be able to offer some advice on a date issue that has me tearing my hair out!
I have an excel spread sheet where:
A = date complaint was received
B = date complaint was responded to
C = the number of days to response,
Another sheet logs bank holidays.
I have used =NETWORKDAYS(A1,B1,anothersheet1:2) to return the number of working days for response and then conditional formatting shows if this is over the 10 working day response target.
All works really well until B is blank. If B is blank I need to determine if a response was due at the end of my quarter 01/04/2012 so:
IF B is blank and A1 to 01/04/2012 is less than 10 network days excluding bank holidays then excel returns “Not Due”
If B is blank and A1 to 01/04/2012 is more than 10 network days excluding bank holidays then excel returns “overdue”
I just seem to be going around in circles – any help would be greatly appreciated!