count between dates

Hi All, I currently have a function that identifies which dates between two dates are Saturdays. What I also need to know though, is how to work out if any of those Saturdays appear in a list of specified dates e.g. Leave//Holidays list of dates. So the below example shows what I'm trying to...

Hi, I'm trying to make an overview of all projects that have been started and in what status they are in. To make a management summary I want to log how long (days) the status "open" or the status "Hold" is activated for the project. But when the X shift between the columns the last status is...

Before submitting this message I did review two similar message board entries, but I wasn't able to figure out how to make the formulas work for me. (I reviewed Count 30, 60 and over 90 days based on Name in Column "A" and Countifs or sumproduct - date range and multiple criteria ) Basically...

Hey guys! New to this forum, and trying to slap together a project to make my mornings a bit easier. I'm looking to count all of the email in a folder and all of its subfolders, and give me a count of each date in the folder. As of now, I have them exporting to excel and giving me a count...

Hi Everyone, this is my first post I have found some great solutions on this site over the last few months but I can find how to do what I am looking for and was hoping someone could help me I run a spread sheet to track absence days at work and need help with how to count specific absence...

Hi, I always struggle with dates and I'm having difficulty working out how many Fridays there are to date in the current year. I have a weekly paying tenant who regularly skips payments (due on Fridays) and then sometimes pays extra to catch up but I'm always having to calculate the arrears...

I have been looking through all the posts and can't find anything that fixes my formula. I have dates in range P5:P88 and some of the cells are blank. I am also trying to bring back the dates, that are equal to today or greater by 30 days based on the values in range F5:F88 Here it is...

Hi All, I have a data set that is ordered by day. Each day can have up to 4 rows. For each day the row has another column to determine if it's a high tide or low tide (simply by and H or L). I need to create a column that for each day will count the number of high tides and low tide values...

Hi All, First post and couldn't find an answer with the exact solution. I am trying to pull numbers for a date range of check-in data per hour per day. For example I'd like to see on 6/1/2015 how many people were checked in at 2 pm, 3 pm, 4 pm, so forth. Here is a small example of the data I...

Hi All, First post and couldn't find an answer with the exact solution. I am trying to pull numbers for a date range of check-in data per hour per day. For example I'd like to see on 6/1/2015 how many people were checked in at 2 pm, 3 pm, 4 pm, so forth. Here is a small example of the data I...

Hi everyone, In an employee list, I am trying to count all leavers in a month based on their position. So far I have: =SUMPRODUCT((P4:P719>='startdate')*(P4:P719<='enddate)) which counts all leavers and works like a charm... but I can't get it to count only the leavers with position "SM"...

Howdy all, Here's the formula I'm currently using to count the number of times an inverter's run mode changes to "off". <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hi there, I have a set of data where the sales rep. creates a visit report. His name can appear in one of 6 fields. I want to count the number of visits and only once per sales rep. per visit. The name can appear on one of 6 columns and not always in the first. How can I count the first...

I need to display basic performance of the recovery department in operating theatres. Ideally... I'd like to see <TBODY> Hour Patients Admitted Patients Discharged Avg Patient LoS Patients In Recovery ... ... ... ... ... 08:00 10 8 01:34:20 15 09:00 5 7 02:24:04 13...

Hi Hi am really new to Excel and am just teaching myself as I go along. Looking on the forum I can see I have a long way to go! I have four columns. One is a start date, two is today, three only populated on completion, four shows me how many weeks. i can work out the weeks for column two -...

Hi All - I'm wondering if there is some type of formula that will count the dates in a column and spit some numbers out. For instance, I have multiple dates in column A rows 1 - 100. I would like the total number of Oct dates in B1, Sept in B2 and the total number of Nov dates in B3. How can...

Hi everyone, I have become stuck on working out a formula to calculate the length of a job counting backwards from todays date to the start, while the job has a status of "WorkInProgress". The other potential status' are "complete", "CreatedInError" and "cancelled". If it is created in...

Hi - I am trying to figure out a formula in Excel 2007 that will count how many meetings take place in any given full 7 day week ongoing (but always Sunday-Saturday). Column A has the meeting start date, column B has the meeting end date. The formula should highlight those meetings that fall...

I need a formula to sum the number of valid data points based on a specified date range. I was able to compute the total sum for a specified date range within a larger data set and avoid any errors within the data set (range) using the SUM formula as shown...

I need to count the number of days between dates in columns. Column A (1/1/12) and column B (1/27/12) = 26 My problem is that I need the formula in each column to be continuous and not enter a 0 if the cell is blank This formula return a VALUE error msg. =DAYS360(B:B,C:C) I have also...