Calculate Years- =DATEDIF(B2,C2,”Y”)

Calculate Months- =DATEDIF(B2,C2,”M”)

Calculate Days- =DATEDIF(B2,C2,”D”)

Calculate Years, Months & Days =DATEDIF(B3,C3,”Y”) & ” Years, ” & DATEDIF(B3,C3,”YM”)&”Months, ” & DATEDIF(B3,C3,”MD”) & ” Days”

Add comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.