Difference between two date

[Tapan Bera]

Hi,

I have a big problem with Date function in Excel.
I need to find out the difference between two date.
Suppose, one baby was born in 10th Feb 2000.
What will be his age now (Yr- Month-Day).

Please help.

[pbmods]

Heya, Tapan.

I'm going to go ahead and move this thread to the Windows forum, where one of our resident Experts will be more likely to see it.

[bartonc]

Heya, Tapan.

I'm going to go ahead and move this thread to the Windows forum, where one of our resident Experts will be more likely to see it.

Sorry, pbmods. The Windows Forum is in the Sys/Admin Group. Excel questions have been relegated to the Misc. Q.s Area. I'm moving it back there.

[pbmods]

Sorry, pbmods. The Windows Forum is in the Sys/Admin Group. Excel questions have been relegated to the Misc. Q.s Area. I'm moving it back there.

Very well then. We'll keep Office-related q's in Misc.

Tapan, take a look at the date and time functions in Excel.

[Tapan Bera]

Hi,

I have gone through all Date Functions available in Excel.
But I did not get my answer.
The Year Function shows no. of Years in between two dates.
The Month Function shows no. of Months in between two dates.
The Day Function shows no. of Days in between two dates.
But I unable to get the Difference between two Dates expressed in Yr.-Month- Date.
Example:

Date 1=10th Feb 2000
Date 2=9th July 2007

Difference = 7 yrs. 4 Months 29 Days

I did not find any formula to solve this problem.

[pbmods]

Heya, Tapan.

=YEAR(A2)-YEAR(A1)-IF(OR(MONTH(A2) <MONTH(A1),AND( MONTH(A2)=MONTH (A1),
DAY(A2)<DAY(A1) )),1,0)&" years, "&MONTH(A2)-MONTH(A1)+IF(AN D(MONTH(A2)
<=MONTH(A1),DAY (A2)<DAY(A1)),1 1,IF(AND(MONTH( A2)<MONTH(A1),D AY(A2)
>=DAY(A1)),12,I F(AND(MONTH(A2) >MONTH(A1),DAY( A2)<DAY(A1)),-1)))&" months,
"&A2-DATE(YEAR(A2),M ONTH(A2)-IF(DAY(A2)<DAY( A1),1,0),DAY(A1 ))&" days"

This is mostly what you need. Play around with it until you get the result you're looking for.

[conorb66]

Try =((YEAR(A2-A1) - 1900) & " Years, " & (MONTH(A2-A1)) & " months, " & (DAY(A2-A1)) & " days")

Where A1 is the first date and A2 is the second date

[Tapan Bera]

Hi,
conorb66
Your answer is showing 1 months extra.
and the answer which is taken from MSDN quite ok but
this formula is showing certain discripency when there will be
a leap year.
Otherwise everything is fine.

Very very thanks for your co-operation.

[DIABLO666]

Hi,

I have a big problem with Date function in Excel.
I need to find out the difference between two date.
Suppose, one baby was born in 10th Feb 2000.
What will be his age now (Yr- Month-Day).

Please help.

Simply type date of birth and then subtract it on the current system date. format cell address to date.