Need Help in Dates

[Santosh080]

Hello Friends

I have data like this, in "Left over period for maturity" cell use formula. (Difference between Maturity Date & Approched date)

Maturity Date	27-01-2017
Approched date	22-12-2013
Left over period for maturity	3 Years 1 Months 5 Days

In next cell i want data like this,

Months (after ignoring the days) = 37 (Here 3 year+1 month)

When i change Maturity Date & Approched date it should updates.

Can it possible ?

Thanks

 

[alansidman]

Book5
	A	B	C	D	E
1	Maturity	1/27/2017
2	Approach	12/22/2013
3	Months	37
4		3 years, 1 months, 5 days
Sheet1

Cell Formulas
Range	Formula
B3	B3	=DATEDIF(B2,B1,"M")
B4	B4	=DATEDIF(B2, B1, "y") &" years, "&DATEDIF(B2, B1, "ym") &" months, " &DATEDIF(B2, B1, "md") &" days"

 

[SanjayGMusafir]

Months (after ignoring the days) = 37 (Here 3 year+1 month)

Your solution is DATEDIF Function. May note it for some reason apparently not appears in Excel so complete the formula and see the results.

DATEDIF function - Microsoft Support

Calculates the number of days, months, or years between two dates.

support.microsoft.com

 

[alansidman]

@SanjayGMusafir​

DateDif does not appear in Excel as it is a holdover from the days of Lotus1-2-3. Excel incorporated several of the 1-2-3 formulas as people migrated to Excel in the early days. It has kept the formula but not made it part of intellisense.