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

 

[jeffreybrown]

Why not just add 1?

=B3-A3+1

 

[AlanY]

try this in C3

=IF(COUNT(A3:B3)=2,B3-A3+1,"")

 

[candybg]

Assuming date in is in A3 and date out is in B3, then C3 could be =B3-A3+1, formatted to a NUMBER so it won't show a date.

 

[sangeeta25]

Thanks AlanY your formula works!!!!!

 

[AlanY]

you're welcome

 

[vicedo]

This should work as well

=IF(COUNT(A3:B3)<2,"",days(B3,A3))

 

[sangeeta25]

Hi AlanY

Thanks again for the formula, is there any way the formula can be amended so that weekends (Saturdays and Sundays) are not included in the count?

 

[AlanY]

try this

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

 

[sangeeta25]

try this

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

Thank you very much!!!