count between dates

1. Count Emails in a Shared Mailbox by date and Export to Excel.

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...
2. how to count occurances of a number being larger than a previous number within a specific time period (rolling 3 months)

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...
3. How to calculate the number of Fridays so far this year...?

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...
4. Countif not returning the correct amount

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...
5. Cumulative Counting in column

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...
6. How to quantify Check-in/out data Per hour Per day

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...
7. How to quantify Check-in/out data Per hour Per day

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...
8. Count within Date Range only if valid criteria

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"...
9. Date-specific PIAdvCalcFilVal formula

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/>...
10. Count if - text could be in one of 6 columns per row

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...
11. Pivot Table Count IF

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...
12. Count difference between columns, in weeks, but stop if third row contains date

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 -...
13. Count Feature with dates **HELP**

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...
14. Count of days open on a job until a different column reads "complete" then keep the count

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...
15. Count number of occurances for each full 7 day week

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...
16. Need Count Based on Date Range

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...
17. Count between dates

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...
18. Countif with date

Hello, I am using Excel 2010 I want to count the number of quotations issued based on the year in which they were issued. The date format is dd/mm/yyyy. So I need to return the number of quotes using the yyyy as the criteria. Your help appreciated.
19. Number of Specific months between two dates?

I want to calculate the number of specific months, between two dates? For example: I want to know the number of September and January Months between 1-June-2006 to 24-December-2010. Please help with a Formula that can do this.
20. Calculate the Networkdays between two dates - as long as they occur within the past year

Hi I'm trying to put together a sickness calculator that works on a rolling year basis. I need to count the number of days between two dates, but only count the weekdays (exclude weekends and bank holidays) and only those dates which fall within the last year. To explain: Let's say that...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back