Hi all,
I'm currently using the DATEDIF formula below to work out the diffrence between two dates contained in B242 and C242.
=DATEDIF(B242,C242,"y")&" years "&DATEDIF(B242,C242,"ym")&" months "&DATEDIF(B242,C242,"md")&" days".
The output displays as X years X months X days which is fantastic...