Prev: Formula
From: TQ on 6 Jun 2010 12:10
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.


From: Don Guillett on 6 Jun 2010 12:27
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(a)gmail.com
"TQ" <TQ(a)discussions.microsoft.com> wrote in message
news:2024AA7E-436E-4C64-9116-E8359CAE3D08(a)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.
>
>

 | 
Pages: 1
Prev: Formula