Maybe you are having a lot of questions like below

How to Calculate the difference between two dates?

Can you subtract dates in Excel?

How do I subtract two date columns in Excel?

How do you calculate the difference between two dates?

Here the answers

Use the DATEDIF function when you want to calculate the difference between two dates. First, put a start date in a cell and an end date in another. Then type a formula like one of the following.

Warning: If the Start_date is greater than the End_date, the result will be #NUM!.

Difference in days

In this example, the start date is in cell D9, and the end date is in E9. The formula is in F9. The “d” returns the number of full days between the two dates

Difference in weeks

In this example, the start date is in cell D13, and the end date is in E13. The “d” returns the number of days. But notice the /7 at the end. That divides the number of days by 7, since there are 7 days in a week. Note that this result also needs to be formatted as a number. Press CTRL + 1. Then click Number > Decimal places: 2.

Difference in months

In this example, the start date is in cell D5, and the end date is in E5. In the formula, the “m” returns the number of full months between the two days.

Difference in years

In this example, the start date is in cell D2, and the end date is in E2. The “y” returns the number of full years between the two days.

By admin

Leave a Reply

Your email address will not be published.