Microsoft Excel Help?

Hello!!!

How can we calculate in Excel Sheet, year, month, days formula?

15-09-2005 to 30-11-2011 (how many years, month, days, in 15-09-2005 to 30-11-2011???)

Thanks guys please reply me !!!!!

Calculate it like this:

=DAYS360(A1,B1,TRUE)

A1 is 15/09/2005 & B1 is 30/11/2011. The answer is 2235.

Let me know for any questions.

[quote=“mateen.khalid, post:2, topic:16243”]

Calculate it like this:

=DAYS360(A1,B1,TRUE)

A1 is 15/09/2005 & B1 is 30/11/2011. The answer is 2235.

Let me know for any questions.

[/quote]

Thank You Mateen, but not this, i did’t mean how many days between 15/09/2005 to 30/11/2011!!!

its mean…

Years = ?

Month = ?

Days = ?

Also is’t possible this formula on MS Word???

Thanks …

http://www.theexceladdict.com/_t/t040303.htm

http://www.cpearson.com/excel/datedif.aspx