countifs dates times

I have a report I pull from one system into Excel format. I process it with some queries in Access and export it out to Excel. At no point do I actually edit the data in the field, but it is getting passed back and forth. The issue does happen in the source document, so the passing back and...

From month to month I'd like to know how many people are still on their work placements. Columns J and K represent the start and end dates of the placement, where columns N represents the last day of the month and column M represents the first day of the month. Column I represent student...

​Hi, I'm not sure where to start with this right now, a little in over my head. I'm trying to create a formula that counts the number of days a month an activity is performed (A) by certain users (B) based off of the transactions (C). The transacation dates also need to be redefined, as the...

Appreciate very much if you could modify my formula to insert another criteria to count number of individuals attends on Mon, Wed, Tue, Thu, & Fri within a required date range specified. I was able to count how many students attended from K29:BN29 (13/09/2015 - 07/11/2015) but I would like to...

Hi guys, I have a large set of data which contains the logs of every single delivery arrived in a factory. Every delivery has its own record in the register. Against every delivery there is an entry date and time stamped and their exit date/time stamped (See sample below). Can you please help...