Useful Excel Trick in HR Payroll

Hey Friends...

As in HR there are some excel formula which makes our task easy.

Today will learn to know the exact years month and day from a specific date to till specific date.

Please follow... if you have any query please comment.

DOB	Today Date	Total Period
15-Aug-90	07-Dec-18	28Years 3Months 23Days

DOB	Today Date	Total Period
15-Aug-90	07-Dec-18	DATEDIF(A2,B2,"Y")&"Years "&DATEDIF(A2,B2,"YM")&"Months "&DATEDIF(A2,B2,"MD")&"Days "