Hi
I want to round up my days to months if over 15, if 15 or under to round down. Not certain whether this is possible, have an example below with my code.

=IF(DATEDIF(D40,C40,"y")=0,"",DATEDIF(D40,C40,"y")&" years ")&IF(DATEDIF(D40,C40,"ym")=0,"",DATEDIF(D40,C40,"ym")&" months ")&DATEDIF(D40,C40,"md")&" days"

DATA - 26/11/2012 and 30/11/2011
RESULT - 11 months 27 days.
WHAT I WANT NOW IS THE RESULT TO BE 12 months

DATA 26/11/2012 AND 24/09/2012
RESULT - 2 months 2 days
WHAT I WANT NOW IS THE RESULT TO BE 2 months.

Hopefully this has explained it

Thanks
Anne