count date range.

  1. R

    Finding consecutive date pattern

    Hi I require a formula that checks dates shown on a row and sees if they are consecutive days, and return the quantity of consecutive days. If possible it also needs to discard weekend days, therefore Thursday 1st, Friday 2nd and Monday 5th will count as 3 consecutive days. Finally, each row...
    • ronie85
    • Thread
    • consecutive count date range. date sequence pattern matching sequence
    • Replies: 8
    • Forum: Excel Questions
  2. F

    Count for Data greater than a particular date range

    <tbody> Name Stages Date Volume Curr Kumar Needs 11-09-2012 2600 INR Sourav Implementation 11-09-2012 5000 INR Akhil Implementation 04-09-2012 14500 INR Murugan Implementation 24-09-2012 12000 INR Sashankh Implementation 28-02-2013 400 INR Arif Implementation 02-04-2013 125 INR...

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