★0 XP
Question 1 of 10
The DATEDIF function (think "date difference") returns the number of days, months, or years between two dates. The first two arguments are the two dates. The third argument is "d", "m", or "y" depending on whether you want the difference in days, months, or years.
To get the number of days between the two dates below, type:
=DATEDIF(B1, B2, "d")
To get the number of days between the two dates below, type:
=DATEDIF(B1, B2, "d")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Start date: | 10/8/1992 | ||
| 2 | End date: | 1/27/2021 | ||
| 3 | ||||
| 4 | ||||
| 5 |
fx