Calculate number of days including both days

Hi,

I am trying to calculate number of days in a date range.

For eg: 1 September and 3 September. I am looking for 3 days. however when i apply datedif i just get difference between both the dates which is 2.

Anybody can help to get 3 as output? since there is 1 sep, 2 sep and 3 sep in the range.

Add 1 to the DATEDIF function =DATEDIF(Start,end,"d")+1

Thanks, But with this alternative, i get 1 in the blank cells , where there is no date entered ( if i extend the formulae in a bigger range)

Is there any direct solution or formula for this??

As you have not defined which empty cell (start or end date) should be checked, the general formula is =IF(emptycell_ref="","",DATEDIF(Start,end,"d")+1 )

serves the purpose, thanks a ton

You're welcome