Trouble with Formula not able need total of days used from

[wic3421]

Hi All,

I am having problems figuring out a formula that would give me the total days used. I have the working days in a month using the networking formula ( I need to include holidays). I need to have the total of Days Used (column 5) including blank cells by subtracting the Date Out (column L) to come up with the total of Days Used. My problem is that I keeping on having errors when because of the blank cells and I need to reference Working Days in Month (P2). Help I need to figure out the Days Used (column M) for 300+ lines.

Thank you in advance.

 

[Adjunctor]

What would be the expected result when you have a blank on Date Out (Col L)?
What do you need to reference the working days value for? what role is playing on your calculations?
In the example you ar posting you have the same dates on both columns, that doesn't make sense, your result will always be zero.

 

[wic3421]

I need to upload columns K-M. Even if there is a blank on Date Out (column L) there has to be a total from the 1st Day of the Month and Days Used (column M).

Even if the answer is 0 I need to have a number there in order to upload the information to the software I am using.

 

[Adjunctor]

Can you tell what would be the correct results for at least the fisrt 3 rows on your example?