Results 1 to 15 of 15

Counting the number of times a date occurs in multiple start and end date ranges.

Threaded View

  1. #1
    Registered User
    Join Date
    06-18-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2013/2016
    Posts
    40

    Counting the number of times a date occurs in multiple start and end date ranges.

    Hi,

    I have a list of start and end dates and would like to count the number of times each date throughout the year appears in these date ranges so that I can plot them to show the busiest periods.

    I have attached an example file. I have been puzzling on this for a while, I was thinking it would be easy to use a COUNTIFS formula to decide whether the date in column D was equal or greater than the date in column B and then if it was equal or less than the date in column C. I have had a brain fade now...I can't remember what I've done now

    Could someone please point me back in the right direction with this?

    Thanks very much..
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1