Question: How to calculate years, months, weeks, days, workdays, hours, minutes and seconds between two dates?

 

Answer: Years: =DATEDIF($A$2,$B$2,"y")
Months: =DATEDIF($A$2,$B$2,"y")
Weeks: =ROUND(DATEDIF($A$2,$B$2,"d")/7,0)
Days: =DATEDIF($A$2,$B$2,"d")
Workdays: =NETWORKDAYS(A2,B2) (Requires Analysis Toolpack)