How to Date Difference in Excel?

1

`=B2-A2`

`=DATEDIF(A2,B2,”d”)`

`=DATEDIF(A2,B2,”m”)`

`=DATEDIF(A2,B2,”y”)`

`=DATEDIF(A2,B2,”ym”)`

`=DATEDIF(A2,B2,”yd”)`

`=DATEDIF(A2,B2,”md”)`

`=NETWORKDAYS(A2,B2)`

`=NETWORKDAYS.INTL(A2,B2)`

`=YEARFRAC(A2,B2)`

`=ABS(B2-A2)`

Suggested for You

Trending Today