Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Needed to Compare Dates and return a running total
I am trying to create a formula that will compare an employee's hire date to
the date of a training class. If the hire date before the training class then count that employee's clock number and if the hire date is after the training class do not count that employee's clock number. Is there away to do this. Example Spreadsheet: Hire Date Employee Clock# Training Class Date 4/15/06 Doe, John 1234 1/6/06 My goal is to create a summary sheet that determines the average of completion for each class and for the enitre company. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Needed to Compare Dates and return a running total
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Needed to Compare Dates and return a running total
Thanks. I will try this.
"Gary L Brown" wrote: Take a look at the SumIf and CountIf functions. HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "Cmonroe" wrote: I am trying to create a formula that will compare an employee's hire date to the date of a training class. If the hire date before the training class then count that employee's clock number and if the hire date is after the training class do not count that employee's clock number. Is there away to do this. Example Spreadsheet: Hire Date Employee Clock# Training Class Date 4/15/06 Doe, John 1234 1/6/06 My goal is to create a summary sheet that determines the average of completion for each class and for the enitre company. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare date against multiple dates | Excel Discussion (Misc queries) | |||
Money "In" Money "Out" Formula | Excel Discussion (Misc queries) | |||
How Do I Add Dates in a formula? | Excel Worksheet Functions | |||
formula to look up and return smallest date from a range of dates | Excel Worksheet Functions | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) |