Counting formula

[sangeeta25]

Hi everyone!

I need help with a formula to do the following action below...

I have column A which says "date in" and column B which says "date out" and then column C which says "number of days"

So what I would like to have is when someone puts in a date in say cell a3, the date being 14/05/2016 and then puts in a date (for date out) in cell b3, the date being 17/05/2016, I would then like for cell C3 to count the days between cell a3 and b3 including the day in a3, so c3 will automatically calculate the number 4 because between the 14th and 17th including the 14th is 4 days.

Can someone please assist?

Thank you in advance!!!

S

 

[AlanY]

that's ok

 

[sangeeta25]

try this

=IF(COUNT(A3:B3)=2,NETWORKDAYS(A3,B3),"")

Hi AlanY

With regards to the above formula, can you please help me so that I can amend the formula so that if in column D the option "other" is selected form the drop down then this does not count

S

 

[AlanY]

may be

=IF(D3="other","",if(COUNT(A3:B3)=2,NETWORKDAYS(A3,B3),""))