Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flagging tasks using Networkdays
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flagging a cell | Excel Worksheet Functions | |||
Flagging with Excel | Excel Discussion (Misc queries) | |||
Flagging constants | Excel Worksheet Functions | |||
Due Date Flagging | Excel Worksheet Functions | |||
Flagging duplicates | Excel Programming |