Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of days in a running period
Hi does anyone know if there is a way to calculate how many days a person has
taken off over a running tweleve month period? For example If a person was off: 2 Days May 06 3 Days December 06 10 April 07 In May the running total would be 15 days, however at the end of June the total would only be 13. Any ideas would be much appreciated |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of days in a running period
=SUMPRODUCT(--(A1:A20=DATE(YEAR(H1)-1,MONTH(H1),1)),B1:B20)
where H1 is the date you want to compare against, it can be any date in the month. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "splodgey" wrote in message ... Hi does anyone know if there is a way to calculate how many days a person has taken off over a running tweleve month period? For example If a person was off: 2 Days May 06 3 Days December 06 10 April 07 In May the running total would be 15 days, however at the end of June the total would only be 13. Any ideas would be much appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I calculate the number of days taken off in a running period | Excel Worksheet Functions | |||
How do i get rid of the period in a whole number? | New Users to Excel | |||
Finding number of particular days in a period | Excel Worksheet Functions | |||
running total for last 7 calender days | Excel Discussion (Misc queries) | |||
Calculating interest on number of days in the period | Excel Worksheet Functions |