Hi there
I have a spreadsheet which I just couldn't figure out what is wrong with the formula.
The following arguments need to be in the formula.
This is how I tried it:
=IF($M5<>"",(IF($I5<$V$1,NETWORKDAYS($H5,$U5),NETWORKDAYS($H5+1,$U5))),(IF($O5>$V$1,NETWORKDAYS($N5,$U5),NETWORKDAYS($N5+1,$U5))))
But I didn't even get it to distinguish between the times
[/IMG]
This drives me nuts Thanks for your help!
I have a spreadsheet which I just couldn't figure out what is wrong with the formula.
The following arguments need to be in the formula.
- I want excel to show me (in row X) how long it took to issue the order. Beginning from the day, the order was created.
- If the order was on credit hold, then it should count from the date the order was released released (crow M) until the order was issued (row P). I also want it to count by workingdays only!
- Anther thing ist, that if the order was placed before noon, then it should count from the first day on, otherwise it should start counting from the next day. This is why I separated day and time.
This is how I tried it:
=IF($M5<>"",(IF($I5<$V$1,NETWORKDAYS($H5,$U5),NETWORKDAYS($H5+1,$U5))),(IF($O5>$V$1,NETWORKDAYS($N5,$U5),NETWORKDAYS($N5+1,$U5))))
But I didn't even get it to distinguish between the times
This drives me nuts Thanks for your help!