**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 !!!!!**

**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.

*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 …**