count between dates

  1. J

    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...
  2. C

    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...
  3. J

    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...
  4. A

    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...
  5. J

    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...
  6. J

    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. D

    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"...
  8. R

    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/>...
  9. C

    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...
  10. K

    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...
  11. P

    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 -...
  12. L

    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...
  13. M

    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...
  14. K

    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...
  15. D

    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...
  16. K

    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...
  17. S

    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.
  18. P

    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.
  19. K

    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...
  20. A

    Help: Return the number of years and months between dates

    Seems simple but I just cannot get this to work. Have 2 date cells, Lease Starts, Lease ends. Need to return how many years, months & days between these dates, rounded up. Example: Lease Start: 23 Mar 2007; Lease Ends 27 April 2008. Result should be: 1 Year 1 Month 5 Days. SO always round up...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top