Calculating days worked based on occurences

**JKAUFFMAN2019** · 10-02-2019, 02:39 PM

I am trying to calculate the total days per month an employee has worked based on the data loaded into the interview log. My goal is to identify how may days they were actually in the office interviewing clients, but so far every formula I have tried comes back as "0" or with an error. I have tried various counts and sumproduct variations, and at this point my brain is just not making sense of what to do. I attached a sample of the interview log I am using currently.

Thank you in advance for your assistance and for solving this for me.

**modytrane** · 10-02-2019, 03:04 PM

See attached.

Used this in B10 on Sept tab.

HTML Code:

I created a helper column on Interview log tab using simple formula to capture unique dates in column A.

HTML Code:

**JKAUFFMAN2019** · 10-02-2019, 03:25 PM

Thank you! This worked perfectly. I spent the last 24 hours bouncing my head off the desk, and it took you 30 minutes!

**JKAUFFMAN2019** · 10-03-2019, 10:38 AM

Question, how would I update the helper column to count if there are different employees?

Calculating days worked based on occurences

LinkBack

Thread Tools

Rate This Thread

Display

Calculating days worked based on occurences

Re: Calculating days worked based on occurences

Re: Calculating days worked based on occurences

Re: Calculating days worked based on occurences

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Average hours worked based on days worked during a pay cycle

Calculating Time worked across days

[SOLVED] Calculating the number of days worked

[SOLVED] Calculating the number of days worked

Calculating the number of days worked

Calculating the number of days worked

Calculating the number of days worked

[SOLVED] Calculating the number of days worked

Bookmarks

Bookmarks

Posting Permissions