Results 1 to 9 of 9

count between dates

Threaded View

  1. #1
    Registered User
    Join Date
    10-15-2008
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2304 Build 16.0.16327.20200) 64-bit
    Posts
    24

    count between dates

    Hi,

    I have a list Open Dates and Closed Dates. What im am trying to achieve is between those dates how many times a 10 day marker was hit, a 20 day, a 25 day and a 30+ days, before the call got closed. If there is no closing dates than nothing will be counted. So in my summary i will have the months listed and than going across the top the headngs 10,20,25,30+ and than beneath that the number of calls that reached the 10,20,25,30+ day period.

    Ive attached an example of what im trying to achieve, although its no where near to complete, in Cell F7 i have attempted something but its no where close. Any hint or a point in the right direction would be appreciated

    Thanks

    Sal
    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