Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Days (to 30), Months (to 12) and Years
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Days (to 30), Months (to 12) and Years
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Days (to 30), Months (to 12) and Years
=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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Days (to 30), Months (to 12) and Years
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" wrote in message ... =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" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Days (to 30), Months (to 12) and Years
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Days (to 30), Months (to 12) and Years
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" wrote in message ... =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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert a number to number of years, months and days | Excel Worksheet Functions | |||
Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
Number of years, months, days between two dates. | Excel Worksheet Functions | |||
Converting number of days to years and months | Excel Worksheet Functions | |||
difference between two dates in years, months and days. | Excel Worksheet Functions |