The Magic of DATEDIF

 

A frequent request I get is how to work out someone’s age from that data of birth quickly and easily.  They’ve seen those long formulas involving integers and 365.25 – scary.  Isn’t there an easier way?  Well – yes there is.  Excel has an undocumented command called DATEDIF which allows you to work out how many years, months or days there are between 2 dates.  Great!  Tell me how.  Write your DOB in cell A1 (remember to type in date format) and =TODAY() in cell B1.  In cell C1 type this formula:  =DATEDIF(A1,B1,”y”) and as if by magic your age appears.  Easy Peasy.  For further help go to www.catraining.net