between 2 dates criteria

  1. TheWaterDog

    IFERROR with IF/AND to catch between 2 dates with multiple results......and failing miserably :(

    I know there are people who are going to want to pull their hair out at my stupidity - I want to apologise in advance but I'm so stuck and I don't even know why. Sheet 1 is Schedule Data (B4:Z4999) Start Date is Column Y End Date is Column Z Data I want to be returned is Column B Sheet 2 is...
  2. J

    Car Park Occupancy rate

    Hello Everyone, Could some genius please help me with formula or ways to find a daily occupancy rate of car park in hourly bases based on transaction of “Date Time IN” and “Date Time OUT”. ? Below are the actual sample of transaction we receive. Note: Drivers can park for more than a day as...
    • Jampa
    • Thread
    • between 2 dates criteria date aggregation occupancy time between dates usage
    • Replies: 20
    • Forum: Excel Questions
  3. C

    Extract unique records with date criteria: between 2 dates

    <tbody> DATE REGION LOWER: 1/14/2016 1/11/2016 WEST UPPER: 1/20/2016 1/12/2016 EAST unique values 1/13/2016 WEST REGION 1/14/2016 NORTH NORTH WEST 1/12/2016 SOUTH NORTH WEST 1/16/2016 NORTH NORTH WEST 1/17/2016 NORTH EAST WEST 1/13/2016 SOUTH WEST WEST...
    • carlmov
    • Thread
    • between 2 dates criteria extract unique values north region west
    • Replies: 28
    • Forum: Excel Questions

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?

Disable AdBlock

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

Disable AdBlock Plus

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
Back
Top