I am having the data in respect of dates, I want the following to be findout by existing the dates, for a future date as on 31-05-2010, or as on 30-06-2010. i.e,. the dates to be converted into years and months from the existing dates. I have got the result by using the following formula which one of our smart, intelligent person who has given in this type of forums.

=DATEDIF(A2,TODAY(),"y")
=DATEDIF(A2,TODAY(),"ym")

Years and months should come in a separate columns. and taking the existing dates for future date.
in the mentioned place instead of "Today" I am putting the date as 31-05-2010, or 30-06-2010, but I am not getting the desired/required result. Please help.
Advance sincere thanks to the solution provider.