dates to be converted into years and months

**gopalakrishnarao1** · 05-04-2010, 04:14 AM

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.

**DonkeyOte** · 05-04-2010, 05:58 AM

Lack of response implies people aren't quite following your requirements.

The best approach would be to post a sample file which illustrates setup and desired results.

**DonkeyOte** · 05-04-2010, 07:02 AM

In fact - please don't bother - stick to your thread at MrExcel.com

http://www.mrexcel.com/forum/showthread.php?t=421759

If you choose to x-post again please have the courtesy to provide links (per the Forum rules) - not doing so will generally lead to your posting rights being revoked.

**gopalakrishnarao1** · 05-04-2010, 08:12 AM

Sincere thanks for the answer/solution. In future definetely I will provide the link where I have posted the thread. In order to get the quick answer and as I have to complete my project work immediately, I have put this thread in this forum. It will not be repeated in future.

Originally Posted by DonkeyOte

In fact - please don't bother - stick to your thread at MrExcel.com

http://www.mrexcel.com/forum/showthread.php?t=421759

If you choose to x-post again please have the courtesy to provide links (per the Forum rules) - not doing so will generally lead to your posting rights being revoked.

**DonkeyOte** · 05-04-2010, 08:23 AM

Originally Posted by gopalakrishnarao1

In order to get the quick answer and as I have to complete my project work immediately, I have put this thread in this forum.

Thanks but that is really no defence - others on the board are busy also and by cross posting you are increasing the likelihood that the spare time they have and are prepared to offer you is being wasted.

Going forward please do not abuse the good nature of those trying to assist you.

The above holds true on all forums - ie MrExcel and here.