Flagging tasks using Networkdays
=VLOOKUP(INT(IF(D8="",TODAY(),D8)-(C8+2+(WEEKDAY(C8)=6)*2+(WEEKDAY(C8)=5)*2)
),{0,"";1,"Amber";2,"Red"},2)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Ross" wrote in message
...
Hi,
I am using a formula:
=IF(IF(D8="",TODAY(),D8)(C8+2),"Red",IF(IF(D8="", TODAY(),D8)=(C8+1),"Amber
",""))
Column C contains dates & time received, column D date and time sent. If
date sent is empty it works on today(). We have two working days to
allocate
tasks. However the formula results in ""Red" if i receive something on a
friday but do not send it till monday. Can anyone give me a clue how to
add
networkdaay funtionality to this.
Many thanks,
Ross
|