Use `=B2-A2` to get the number of days between two dates
Use `=DATEDIF(A2,B2,”d”)` to get the number of days between two dates
Use `=DATEDIF(A2,B2,”m”)` to get the number of complete months between two dates
Use `=DATEDIF(A2,B2,”y”)` to get the number of complete years between two dates
Use `=DATEDIF(A2,B2,”md”)` to get the day difference ignoring months and years
Use `=DATEDIF(A2,B2,”ym”)` to get the month difference ignoring years
Use `=DATEDIF(A2,B2,”yd”)` to get the day difference ignoring years
Use `=B2-A2` and format the result as a number if needed
Use `=NETWORKDAYS(A2,B2)` to calculate working days between two dates
Use `=NETWORKDAYS.INTL(A2,B2)` to calculate working days with custom weekends
Use `=B2-A2+1` to include both the start date and end date
Use `=ABS(B2-A2)` to get the absolute date difference regardless of order