Hi, I need the fomula for below scenario, 

A4 = start date  (exp.= 01.03.2007)
B4 = end date   (exp. = 31.05.2012)
D1 = 01.04.2007
D2=  31.03.2008
E1=   01.04.2008
E2=   31.03.2012

F1 =  >31.03.2012

at D4 =  fomula to get the answer of days which fall between A4 & B4?  
(365days)
    D4 =   fomula to get the answer ?  (1460days)

G4 - total period which date fall>D1 (answer shown in month and days.  Ans = 
5 yrs & 2 mths.

Any solution ? Thanks.



Thanks.

Analysistoolpak addin must be installed
=DATEDIF(A4,b4,"y")&" yrs "&DATEDIF(A4,b4,"ym")&" mths"
=DATEDIF(A4,B4,"d")
-- 
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett@gmail.com
"TQ" <TQ@discussions.microsoft.com> wrote in message 
news:2024AA7E-436E-4C64-9116-E8359CAE3D08@microsoft.com...
> Hi, I need the fomula for below scenario,
>
> A4 = start date  (exp.= 01.03.2007)
> B4 = end date   (exp. = 31.05.2012)
> D1 = 01.04.2007
> D2=  31.03.2008
> E1=   01.04.2008
> E2=   31.03.2012
>
> F1 =  >31.03.2012
>
> at D4 =  fomula to get the answer of days which fall between A4 & B4?
> (365days)
>    D4 =   fomula to get the answer ?  (1460days)
>
> G4 - total period which date fall>D1 (answer shown in month and days.  Ans 
> =
> 5 yrs & 2 mths.
>
> Any solution ? Thanks.
>
>
>
> Thanks.
>
>