I need to calculate the number of days or months between two dates in my Excel worksheet. What is the process for calculating the difference between dates in Excel?
Shathana. S.R. Answered question
- Use DATEDIF to find the total years
- Use DATEDIF again with “ym” to find months.
- Use a different formula to find days.
I can calculate by these methods.
Shathana. S.R. Answered question
Enter =C2-B2, then hit RETURN. The result is displayed in Excel as the number of days between the two dates (104). Cell D2 should be selected. Excel automatically changes the cell references to incorporate the right values for each row.
Vishalini.R Answered question
Type =C2-B2, and then press RETURN and it displays the result as the number of days between the two dates
Sandhya Answered question