date count

  1. U

    Count of date values which are in different columns but are of same week in pivot table

    Hi All, I have a data table where we have Roles (varies) that people have been contacted for. Columns B:G contains the dates of the activity performed (e.g. when were they sourced, when they shared their interest so on and so forth). I need a dynamic weekly report which gives us count of all...
  2. R

    Count formula required that falls within a date range

    I need a formula to count cells of other columns that falls within the dates of July month. Please check the screenshot below and let me know your suggestions. It should ONLY count the non-blank cells of Micky Thanks in advance

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