I have two dates in two columns and want to calculate their difference in Years and Months only.
in Column A - Date2 = 04/01/2014
in Column B - Date1 = 02/16/2013
their difference should be:
in Column C (Date2 - Date1) = 1.1 (because only 1 year and 1 month is completed)
in Column D (Today - Date1) = 0.9
Which means about the format (Y.m), before decimal shows years and after it shows month difference.
I have also tested with DateDiff function in VBA, but it everytime does not give the correct answers.
Please find the attached file of my efforts and help me to solve this puzzle.