Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statements
John in Wembley,
First, why are you using the Date() function? It appears that G13 is already a data an all you are doing is adding days. I would change the formula you posted to: =IF(H13="Logged",G13+1,IF(H13="Acknowledged",G13+2 0)) Then, instead of adding 1 or 20, you might look into adding NETWORKDAYS() or WORKDAY() HTH, Conan "John in Wembley" wrote in message ... Im using the following formula to set to date by which a complaint need to be processed by our manger. =IF(H13="Logged",DATE(YEAR(G13),MONTH(G13),DAY(G13 )+1),IF(H13="Acknowledged",DATE(YEAR(G13),MONTH(G1 3),DAY(G13)+20))) He has 1 day to responde to a logged complaint, 20 days onces its being acknowledged to respond... Now the boss says, he wants 20 working days. Is it any way possible to include network days? Ive tried but I think it cant be done. So its 1 day for the manger to acknowledge a logged complaint, 20 working days to respond. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statements
On Thu, 31 Jan 2008 19:59:56 GMT, "Conan Kelly"
wrote: John in Wembley, First, why are you using the Date() function? It appears that G13 is already a data an all you are doing is adding days. I would change the formula you posted to: =IF(H13="Logged",G13+1,IF(H13="Acknowledged",G13+2 0)) Then, instead of adding 1 or 20, you might look into adding NETWORKDAYS() or WORKDAY() HTH, Conan Thanks for that, it was silly of me to be using the date function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if then statements | Excel Worksheet Functions | |||
If then statements | Excel Discussion (Misc queries) | |||
If And statements -- HELP! | Excel Worksheet Functions | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
If Statements: | Excel Discussion (Misc queries) |