Thread: Date difrence in years and months
View Single Post
 
Old 01-03-2024, 05:07 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
in cell E2:
Code:
=DATEDIF($B2,E$1,"y")&" yrs "& DATEDIF($B2,E$1,"ym") & " months"
Copy down (and across if you want).
Reply With Quote