Posted to microsoft.public.excel.worksheet.functions

Posts: n/a

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I convert a number to number of years, months and days	because	Excel Worksheet Functions	2	October 12th 05 06:15 PM
Function to calculate the number of years, months and days between	Vicky	Excel Worksheet Functions	2	July 15th 05 04:27 AM
Number of years, months, days between two dates.	Bluenose	Excel Worksheet Functions	34	June 30th 05 02:18 PM
Converting number of days to years and months	Dave Cobb	Excel Worksheet Functions	4	May 24th 05 09:14 PM
difference between two dates in years, months and days.	ruby	Excel Worksheet Functions	2	April 4th 05 04:51 PM

All times are GMT +1. The time now is 12:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us