Formula Needed to Compare Dates and return a running total

C

Cmonroe

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.
 
C

Cmonroe

Thanks. I will try this.

Gary L Brown said:
Take a look at the SumIf and CountIf functions.
HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.
 
C

Cmonroe

Gary, this is as far as I can get. I am fairly new to formulas. Please
help. Here is my logic.

If the employee's Hire Date (E2:E466) is before Training Date (U468:AZ468)
then count the employee's clock number and keep a running total. I do not
know if this is possible.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top