Thread: How to Calculate Age in Years, Months, and Days?
View Single Post
  #2  
Old 07-15-2024, 04:35 PM
Tann Tann is offline
Planar Protector

Tann's Avatar

Join Date: Oct 2010
Posts: 1,123
Default
Excel, put a date in A1 then use:

Code:
=DATEDIF(A1, TODAY(), "Y") & " years, " & DATEDIF(A1, TODAY(), "YM") & " months, and " & DATEDIF(A1, TODAY(), "MD") & " days"
__________________
< Knights Who Say Ni >
Qeynos questing and leveling (all quests nerfed) | Off the beaten path 24-40.
Reply With Quote