Future Date - TODAY() : not giving expected result

hi Simon, you cannot format it like this because Excel recognises dates as integers & time as decimals. to verify, type in 1jan2013 in A1. and 12 pm in B1. Format both cells to General. you will see that A1 is 41275 (meaning 41,275th day from 1 Jan 1900) & B1 is 0.5 (1/2 a day).*

so when you have 31, and it shows you 01 months, it actually means January. you would have to use this instead of the C2-TODAY portion:
=TEXT(DATEDIF(TODAY(),C2,"y"),"00")&" years "&TEXT(DATEDIF(TODAY(),C2,"ym"),"00")&" months "&TEXT(DATEDIF(TODAY(),C2,"md"),"00")&" days"

just to be clear. if today is 8 Oct & C2 is:
8 Oct - it should be 0 years 1 months 0 days cause it's 1 month from today
7 Oct - it should be 0 years 0 months 30 days cause it's 30 days from today
9 Oct - it should be 0 years 1 months 1 days cause it's 1 month & a day from today