I used the following formula to calculate the difference between two dates:

=DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
"&DATEDIF(A2,B2,"md") & " days"

01/01/2006 28/02/2006 0 years, 1 months, 27 days
01/01/2006 31/01/2006 0 years, 0 months, 30 days

Which is ok but I would want the result for the first example to be 2 months
and for the second example 1 month.

Should I use another formula?

Thanks in advance
Deborah

Deborah wrote:
> I used the following formula to calculate the difference between two
> dates:
>
> =DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
> "&DATEDIF(A2,B2,"md") & " days"
>
> 01/01/2006 28/02/2006 0 years, 1 months, 27 days
> 01/01/2006 31/01/2006 0 years, 0 months, 30 days
>
> Which is ok but I would want the result for the first example to be 2
> months and for the second example 1 month.
>
> Should I use another formula?
>
> Thanks in advance
> Deborah

Hi Deborah,

try with this modified formula:

=DATEDIF(A2,B2+1,"y") & " years, " & DATEDIF(A2,B2+1,"ym") & " months,
"&DATEDIF(A2,B2+1,"md") & " days"



--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

It seems to work.

Many thanks.

Deborah from Italy


"Franz Verga" wrote:

> Deborah wrote:
> > I used the following formula to calculate the difference between two
> > dates:
> >
> > =DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
> > "&DATEDIF(A2,B2,"md") & " days"
> >
> > 01/01/2006 28/02/2006 0 years, 1 months, 27 days
> > 01/01/2006 31/01/2006 0 years, 0 months, 30 days
> >
> > Which is ok but I would want the result for the first example to be 2
> > months and for the second example 1 month.
> >
> > Should I use another formula?
> >
> > Thanks in advance
> > Deborah
>
> Hi Deborah,
>
> try with this modified formula:
>
> =DATEDIF(A2,B2+1,"y") & " years, " & DATEDIF(A2,B2+1,"ym") & " months,
> "&DATEDIF(A2,B2+1,"md") & " days"
>
>
>
> --
> Hope I helped you.
>
> Thanks in advance for your feedback.
>
> Ciao
>
> Franz Verga from Italy
>
>
>

Deborah wrote:
> It seems to work.
>
> Many thanks.

You're welcome.

> Deborah from Italy


There's also the italian speaking newsgroup:

microsoft.public.it.office.excel



--
Glad I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Hi Franz, I tried your modified formula but it does not work. For example
14.02.1980 01.04.1995 15 years, 1 month, 19 days
whereas the actual difference is 15 years, 1 month, 17 days including both
monthdays. The actual and modified formula both give incorrect results. I
think excel is not able to work out the days of February days, specially for
the years divisible by 4, 100, 400 and 1600. Can anybody help me.
Thanks,
Javaid from Pakistan.

"Franz Verga" wrote:

> Deborah wrote:
> > I used the following formula to calculate the difference between two
> > dates:
> >
> > =DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
> > "&DATEDIF(A2,B2,"md") & " days"
> >
> > 01/01/2006 28/02/2006 0 years, 1 months, 27 days
> > 01/01/2006 31/01/2006 0 years, 0 months, 30 days
> >
> > Which is ok but I would want the result for the first example to be 2
> > months and for the second example 1 month.
> >
> > Should I use another formula?
> >
> > Thanks in advance
> > Deborah
>
> Hi Deborah,
>
> try with this modified formula:
>
> =DATEDIF(A2,B2+1,"y") & " years, " & DATEDIF(A2,B2+1,"ym") & " months,
> "&DATEDIF(A2,B2+1,"md") & " days"
>
>
>
> --
> Hope I helped you.
>
> Thanks in advance for your feedback.
>
> Ciao
>
> Franz Verga from Italy
>
>
>

Hi Franz, I tried your modified formula but it does not work. For example
14.02.1980 01.04.1995 15 years, 1 month, 19 days
whereas the actual difference is 15 years, 1 month, 17 days including both
monthdays. The actual and modified formula both give incorrect results. I
think excel is not able to work out the days of February days, specially for
the years divisible by 4, 100, 400 and 1600. Can anybody help me.
Thanks, waiting for the reply.
Javaid from Pakistan.

"Franz Verga" wrote:

> Deborah wrote:
> > I used the following formula to calculate the difference between two
> > dates:
> >
> > =DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
> > "&DATEDIF(A2,B2,"md") & " days"
> >
> > 01/01/2006 28/02/2006 0 years, 1 months, 27 days
> > 01/01/2006 31/01/2006 0 years, 0 months, 30 days
> >
> > Which is ok but I would want the result for the first example to be 2
> > months and for the second example 1 month.
> >
> > Should I use another formula?
> >
> > Thanks in advance
> > Deborah
>
> Hi Deborah,
>
> try with this modified formula:
>
> =DATEDIF(A2,B2+1,"y") & " years, " & DATEDIF(A2,B2+1,"ym") & " months,
> "&DATEDIF(A2,B2+1,"md") & " days"
>
>
>
> --
> Hope I helped you.
>
> Thanks in advance for your feedback.
>
> Ciao
>
> Franz Verga from Italy
>
>
>

=DATEDIF(E5,TODAY(),"Y") & " Years "
i have used this formula, but i do not want the word years to show up in the
cell, how do i modify it.

"Franz Verga" wrote:

> Deborah wrote:
> > I used the following formula to calculate the difference between two
> > dates:
> >
> > =DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
> > "&DATEDIF(A2,B2,"md") & " days"
> >
> > 01/01/2006 28/02/2006 0 years, 1 months, 27 days
> > 01/01/2006 31/01/2006 0 years, 0 months, 30 days
> >
> > Which is ok but I would want the result for the first example to be 2
> > months and for the second example 1 month.
> >
> > Should I use another formula?
> >
> > Thanks in advance
> > Deborah
>
> Hi Deborah,
>
> try with this modified formula:
>
> =DATEDIF(A2,B2+1,"y") & " years, " & DATEDIF(A2,B2+1,"ym") & " months,
> "&DATEDIF(A2,B2+1,"md") & " days"
>
>
>
> --
> Hope I helped you.
>
> Thanks in advance for your feedback.
>
> Ciao
>
> Franz Verga from Italy
>
>
>

Hello George

=DATEDIF(E5,TODAY(),"Y")

HTH
Cordially
Pascal


"George" <(E-Mail Removed)> a écrit dans le message de news:
2860E1C7-158F-4752-A598-(E-Mail Removed)...
> =DATEDIF(E5,TODAY(),"Y") & " Years "
> i have used this formula, but i do not want the word years to show up in
> the
> cell, how do i modify it.
>
> "Franz Verga" wrote:
>
>> Deborah wrote:
>> > I used the following formula to calculate the difference between two
>> > dates:
>> >
>> > =DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
>> > "&DATEDIF(A2,B2,"md") & " days"
>> >
>> > 01/01/2006 28/02/2006 0 years, 1 months, 27 days
>> > 01/01/2006 31/01/2006 0 years, 0 months, 30 days
>> >
>> > Which is ok but I would want the result for the first example to be 2
>> > months and for the second example 1 month.
>> >
>> > Should I use another formula?
>> >
>> > Thanks in advance
>> > Deborah
>>
>> Hi Deborah,
>>
>> try with this modified formula:
>>
>> =DATEDIF(A2,B2+1,"y") & " years, " & DATEDIF(A2,B2+1,"ym") & " months,
>> "&DATEDIF(A2,B2+1,"md") & " days"
>>
>>
>>
>> --
>> Hope I helped you.
>>
>> Thanks in advance for your feedback.
>>
>> Ciao
>>
>> Franz Verga from Italy
>>
>>
>>

Thanks Papou, but this does not work, it sends back a date, (such as
2/18/06), but i am looking for the difference in years, (46)

"papou" wrote:

> Hello George
>
> =DATEDIF(E5,TODAY(),"Y")
>
> HTH
> Cordially
> Pascal
>
>
> "George" <(E-Mail Removed)> a écrit dans le message de news:
> 2860E1C7-158F-4752-A598-(E-Mail Removed)...
> > =DATEDIF(E5,TODAY(),"Y") & " Years "
> > i have used this formula, but i do not want the word years to show up in
> > the
> > cell, how do i modify it.
> >
> > "Franz Verga" wrote:
> >
> >> Deborah wrote:
> >> > I used the following formula to calculate the difference between two
> >> > dates:
> >> >
> >> > =DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
> >> > "&DATEDIF(A2,B2,"md") & " days"
> >> >
> >> > 01/01/2006 28/02/2006 0 years, 1 months, 27 days
> >> > 01/01/2006 31/01/2006 0 years, 0 months, 30 days
> >> >
> >> > Which is ok but I would want the result for the first example to be 2
> >> > months and for the second example 1 month.
> >> >
> >> > Should I use another formula?
> >> >
> >> > Thanks in advance
> >> > Deborah
> >>
> >> Hi Deborah,
> >>
> >> try with this modified formula:
> >>
> >> =DATEDIF(A2,B2+1,"y") & " years, " & DATEDIF(A2,B2+1,"ym") & " months,
> >> "&DATEDIF(A2,B2+1,"md") & " days"
> >>
> >>
> >>
> >> --
> >> Hope I helped you.
> >>
> >> Thanks in advance for your feedback.
> >>
> >> Ciao
> >>
> >> Franz Verga from Italy
> >>
> >>
> >>
>
>
>

Format cell as standard number.

HTH
Cordially
Pascal

"George" <(E-Mail Removed)> a écrit dans le message de news:
68AAD342-90EB-4F8D-9B5B-(E-Mail Removed)...
> Thanks Papou, but this does not work, it sends back a date, (such as
> 2/18/06), but i am looking for the difference in years, (46)
>
> "papou" wrote:
>
>> Hello George
>>
>> =DATEDIF(E5,TODAY(),"Y")
>>
>> HTH
>> Cordially
>> Pascal
>>
>>
>> "George" <(E-Mail Removed)> a écrit dans le message de
>> news:
>> 2860E1C7-158F-4752-A598-(E-Mail Removed)...
>> > =DATEDIF(E5,TODAY(),"Y") & " Years "
>> > i have used this formula, but i do not want the word years to show up
>> > in
>> > the
>> > cell, how do i modify it.
>> >
>> > "Franz Verga" wrote:
>> >
>> >> Deborah wrote:
>> >> > I used the following formula to calculate the difference between two
>> >> > dates:
>> >> >
>> >> > =DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
>> >> > "&DATEDIF(A2,B2,"md") & " days"
>> >> >
>> >> > 01/01/2006 28/02/2006 0 years, 1 months, 27 days
>> >> > 01/01/2006 31/01/2006 0 years, 0 months, 30 days
>> >> >
>> >> > Which is ok but I would want the result for the first example to be
>> >> > 2
>> >> > months and for the second example 1 month.
>> >> >
>> >> > Should I use another formula?
>> >> >
>> >> > Thanks in advance
>> >> > Deborah
>> >>
>> >> Hi Deborah,
>> >>
>> >> try with this modified formula:
>> >>
>> >> =DATEDIF(A2,B2+1,"y") & " years, " & DATEDIF(A2,B2+1,"ym") & " months,
>> >> "&DATEDIF(A2,B2+1,"md") & " days"
>> >>
>> >>
>> >>
>> >> --
>> >> Hope I helped you.
>> >>
>> >> Thanks in advance for your feedback.
>> >>
>> >> Ciao
>> >>
>> >> Franz Verga from Italy
>> >>
>> >>
>> >>
>>
>>
>>