countifs between dates

Just like it says on the tin! I am trying to produce a table (below) that shows the number of employees in each department depending their start date and leaving date (leaving date is blank if they are still an employee) This is my formula...

Hi After two days and no hair left (I didn't want to jump straight to the forum) I am in need of your help once more. I have a spreadsheet that is totalling up fields from another tab. What I am looking to do is to count up column if it has certain text in and with in a date range. the...

Hi everyone, Every month I get this table (Clients) where I am given costs broken out by rows of clients and columns of weeks. However, I need to summarize these values by Client and Month instead of week (Sheet2). Pivot tables don't seem to read across columns and my current sumproduct...

Hi, I'm trying to build out this excel file to keep track of my finances. I could use some help with several formulas revolving around the pay schedule of a year. Any help would be appreciated and I can try toying around. I have a hard-coded list of all the pay dates in a year, for a...

Hi, I need a formula that will allow me to count the number of account Approved or Active between a date range A B Active 1/01/19 Approved 1/19/19 Active 2/10/19 Pending 2/20/19 Close 3/15/19 Thanks, Carlos

Hi again and thanks in advance for your help. I'm trying to count all of a particular name that meets certain criteria. For example: i'm trying to count all "ASC" in coliumn B providing that column C has data in it but the date in column A need to fall between dates in two particular cells...