post #1 of 1
Thread Starter 
I can get someone's age in years for example with the following formula:

=INT((TODAY()-B3)/365.25)

However, what if I need to make it more specific, like years + months?

I'd like the result to look something (using the above example, where B3 is a date value of 1/1/2001) like 10 years, 2 months...or even better yet....10 years, 2 months, 29 days.

Is that possible?
Gaming PC
(12 items)
 
  
CPUGraphicsRAMHard Drive
i7-4790K @ 4.0 GHz NVidia GTX 770 32GB 240GB SSD, (2) Hitachi Deskstar 500GB 7200 RAID 0 
Optical DriveOSMonitorKeyboard
Lite-on DVDRW Windows 7 64-bit 27" AOC @ 1920x1080 Logitech Y-UY95 
PowerCaseMouseMouse Pad
Rosewill 450w Gold Generic Logitech G9 Razer Goliathus 
  hide details  
Reply
Gaming PC
(12 items)
 
  
CPUGraphicsRAMHard Drive
i7-4790K @ 4.0 GHz NVidia GTX 770 32GB 240GB SSD, (2) Hitachi Deskstar 500GB 7200 RAID 0 
Optical DriveOSMonitorKeyboard
Lite-on DVDRW Windows 7 64-bit 27" AOC @ 1920x1080 Logitech Y-UY95 
PowerCaseMouseMouse Pad
Rosewill 450w Gold Generic Logitech G9 Razer Goliathus 
  hide details  
Reply