Carlos85

Hi thanks for the quick reply, I realise now what you mean about the different formulas, I've tried the same formula in the correct place with the same result.

Hi all, thank you so much for all your help, I've tried to use the formula but I cant seem to get it to work. I keep getting an #NAME? Again sorry im not an Excel person! Can anyone just point me in the right direction! thanks

Hi im not really an Excel person but need some help if anyone knows a formula to the below please, I've been looking online but the ones I've come across all relate to a full date 01/02/2021 ect. Example: Theres two different ways i can write the equation. 6 Years, 2 Months (Difference) 7 Years, 8 Months =18 Months or 4.3(4Years/3Months) 6.9(6years/9months) =30 Months Ideally I'd like the end answer/Solution to be in months if possible please Thanks everyone!