Different Between to dates in excel | MS-EXCEL Tutorials

 First Write your data if you don't have data then you can use any dummy data or copy from below

You can copy dummy text from here

Start   Date	End Date	Completed Years	Completed Months	Completed Days
01-01-2020	02-01-2022
02-01-2020	03-01-2023
03-01-2020	04-01-2028
06-08-1999	28-12-2020

Now in the cell of completed years write the formula =DATEDIF(B3,C3,"Y"). B3 Indicated the starting date and C3 indicated to end date. When you want to know diffrence about years then use "Y" If Months Then use "M" and if you want to check days then use "D"

Now you can drag it for all rows

Now moving to months =DATEDIF(B3,C3,"M")

Now Moving to days =DATEDIF(B3,C3,"D")

You can use this formula for checking bulk age at onece 

Tags.

how to calculate difference between two dates and times in excel.

number of days between two dates excel.

excel date difference in months,

excel formula to count days from date to today,

datedif excel,

excel formula to calculate number of days between today and another date,

excel between two dates,

days between dates excel,