+ Reply to Thread
Results 1 to 3 of 3

need a average and find date

  1. #1
    Registered User
    Join Date
    07-31-2012
    Location
    cape cod
    MS-Off Ver
    Excel 2003
    Posts
    33

    need a average and find date

    Hi -

    I'm stuck with a formula for finding an average and then looking at the date. Basically I have a list of employees in the rows and the payroll dates in the columns. I need a formula that will look at the entire row of the employee and when it averages 35 hours it grabs the date at the top of the column.
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,610

    Re: need a average and find date

    Does the average have to be exactly 35 ? What if there are different possibilities?

  3. #3
    Registered User
    Join Date
    07-31-2012
    Location
    cape cod
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: need a average and find date

    Actually no 35 or greater.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1