Hello!
I have:
YY MM DD
2 9 20
4 3 15
I would like your help for the next result after sum periods:
YY MM DD
7 1 5
Thanks in advance.
an
Hello!
I have:
YY MM DD
2 9 20
4 3 15
I would like your help for the next result after sum periods:
YY MM DD
7 1 5
Thanks in advance.
an
Hi Just Extend the logic posted to your previous question on years and months.
=SUM(A2:A3)+INT(SUM(B2:B3)/12)
in Cell B4
=MOD(SUM(B2:B3),12)+INT(SUM(C2:C3)/30)
in cell C4
=MOD(SUM(C2:C3),30)
Note
This will not be accurate due to variation in month lengths.
Regards
Roger Govier
an wrote:
> Hello!
>
> I have:
>
> YY MM DD
> 2 9 20
> 4 3 15
>
> I would like your help for the next result after sum periods:
>
> YY MM DD
> 7 1 5
>
> Thanks in advance.
> an
>
>
=YEAR(DATE(A1+A2,B1+B2,C1+C2))-1900
=MONTH(DATE(A1+A2,B1+B2,C1+C2))
=DAY(DATE(A1+A2,B1+B2,C1+C2))
But you get 4, not 5 for the day.
--
Kind regards,
Niek Otten
"an" <[email protected]> wrote in message
news:[email protected]...
> Hello!
>
> I have:
>
> YY MM DD
> 2 9 20
> 4 3 15
>
> I would like your help for the next result after sum periods:
>
> YY MM DD
> 7 1 5
>
> Thanks in advance.
> an
>
>
In this case. If your data were
2 9 20
4 5 15
you would get 7 for the day
--
Kind regards,
Niek Otten
"Niek Otten" <[email protected]> wrote in message
news:%[email protected]...
> =YEAR(DATE(A1+A2,B1+B2,C1+C2))-1900
> =MONTH(DATE(A1+A2,B1+B2,C1+C2))
> =DAY(DATE(A1+A2,B1+B2,C1+C2))
>
> But you get 4, not 5 for the day.
>
> --
> Kind regards,
>
> Niek Otten
>
> "an" <[email protected]> wrote in message
> news:[email protected]...
>> Hello!
>>
>> I have:
>>
>> YY MM DD
>> 2 9 20
>> 4 3 15
>>
>> I would like your help for the next result after sum periods:
>>
>> YY MM DD
>> 7 1 5
>>
>> Thanks in advance.
>> an
>>
>>
>
>
Exactly, RG
Many thanks, more one time.
an
"Roger Govier" wrote:
> Hi Just Extend the logic posted to your previous question on years and months.
>
> =SUM(A2:A3)+INT(SUM(B2:B3)/12)
> in Cell B4
> =MOD(SUM(B2:B3),12)+INT(SUM(C2:C3)/30)
> in cell C4
> =MOD(SUM(C2:C3),30)
>
> Note
> This will not be accurate due to variation in month lengths.
>
> Regards
>
> Roger Govier
>
>
> an wrote:
> > Hello!
> >
> > I have:
> >
> > YY MM DD
> > 2 9 20
> > 4 3 15
> >
> > I would like your help for the next result after sum periods:
> >
> > YY MM DD
> > 7 1 5
> >
> > Thanks in advance.
> > an
> >
> >
>
Thanks, too.
an
"Niek Otten" wrote:
> In this case. If your data were
> 2 9 20
> 4 5 15
>
> you would get 7 for the day
>
> --
> Kind regards,
>
> Niek Otten
>
> "Niek Otten" <[email protected]> wrote in message
> news:%[email protected]...
> > =YEAR(DATE(A1+A2,B1+B2,C1+C2))-1900
> > =MONTH(DATE(A1+A2,B1+B2,C1+C2))
> > =DAY(DATE(A1+A2,B1+B2,C1+C2))
> >
> > But you get 4, not 5 for the day.
> >
> > --
> > Kind regards,
> >
> > Niek Otten
> >
> > "an" <[email protected]> wrote in message
> > news:[email protected]...
> >> Hello!
> >>
> >> I have:
> >>
> >> YY MM DD
> >> 2 9 20
> >> 4 3 15
> >>
> >> I would like your help for the next result after sum periods:
> >>
> >> YY MM DD
> >> 7 1 5
> >>
> >> Thanks in advance.
> >> an
> >>
> >>
> >
> >
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks