MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Can anyone provide me the fomula ?

• Follow

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.

 0

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

 0

1 Replies
633 Views

Similiar Articles:

7/26/2012 4:12:43 PM