Datedif with if statement

[Imran Azam]

Hi Guys

I am trying to write a formula to get the number of days between two dates , i also want to state if both dates dates are the same then return value 1 else o bring back the difference

I have created the date difference formula below how can i add an if statement to return 1 if dates are same in this formula?

= DATEDIF(A2,E2,"d")

thank you

 

[AlanY]

try

= if(A2=E2,1,DATEDIF(A2,E2,"d"))

 

[alpadem]

= IF(A2=E2,1, DATEDIF(A2,E2,"d"))

 

[Imran Azam]

thank you both that was correct
thanks for your help

 

[FormR]

Hi, you don't need to use the undocumented datedif() function to calculate the number of days between two dates - you can simply take one from the other, for example:

=IF(A2=E2,1,E2-A2)