Sum of rows with date format

[JoseL]

Hi,

I have a column with several rows that show dates.
I would like to show in a cell the sum of all the months months, in other the sum of the days and the sum of the years in other one.

Ex.
9/12/2008
10/11/2008
10/21/2008

Sum of the months: 29.
Sum of the days: 44.
Sum of the years: 6024.

I know how to do it with just only two dates, but not with several.

Thanks a lot.

 

[namliam]

Look into the Year() Month() and Day() functions... then you can just sum them in a query or something... Tho WHY you would want to do this?

- Likely some school work or something ? -

 

[JoseL]

Hi Mailman,

Thanks a lot for your help but I don't get it.
I know how to do it if I separate the month, day and year for each date in new cells and later on I sum all of the rows. But I was wondering if I could do that with just only one step.

The thing to do this is because sometimes we have temporary employees that have been working for several periods and if for some reason they became indefinite I have to calculate a seniority date making a calculation based on the start and end dates for each period.

Thanks a lot anyway.

 

[namliam]

But you dont go around adding dates together like that to calculate seniority....

For each period they worked you have a startdate and enddate right?
Take a datediff (look it up in the help if you dont know the function) for each period, then sum those periods and you should get a total of worked days/weeks/months/years (whatever you choose) and be able to see/sort on/whatever seniority

 

[namliam]

Oh wait ... this is in excel... Datediff dont work....

Just take the enddate - startdate and use the sumif function to get to the total days "worked"

 

[JoseL]

Well, I have to do it in that way and later apply some more calculation I don't have problem with, and of course I have startdate and enddate fields.

But don't worry, I know how to do it with Access, the thing was if there is anyway to do it with Excel.

Thanks a lot Mailman.

 

[JoseL]

Well, I have to do it in that way and later apply some more calculation I don't have problem with, and of course I have startdate and enddate fields.

But don't worry, I know how to do it with Access, the thing was if there is anyway to do it with Excel.

Thanks a lot Mailman.

 

[chergh]

Have a look at the 'networkdays' function.

 

[Brianwarnock]

Oh wait ... this is in excel... Datediff dont work....

QUOTE]

Datedif, note the single f , still worked in 2002 sp3 . Does it still work in 2007?

Brian