count dates by criteria

  1. 8

    Sumproduct? Countifs? multiple criteria and dates (January and blank cells messing everything up)

    I have dates in column A, (but some blanks), then column B has X, Y, or Z. The zero's were messing up my Countif and including them in the January total, but in the end I managed to count the number of occurrences for each moth by using : =SUMPRODUCT(--(MONTH(A2:A500)=1),--(MONTH(A2:A500<>0))...
  2. H

    Help needed! Google Sheets count dates from last month?

    Dear Everyone! I want to ask your help. I have read all about this forum, but the solutions i've found, not work for me in google sheets. My wife leads a Development Centre that helps little children to develop motor skills. At the beginning of a new month, she has to send a report to the...
  3. S

    Counting late payment dates

    Hi all. I normally get paid on the 15th of every month, though sometimes this could be later. If I enter the actual payment dates in A1:A12, which formula can I use to count the number of times they were made late?
  4. L

    Count formula

    Good evening all. I wish to generate a simple invoice based on the YYMM number of occurrences for a simple database to do a simple mailmerge. Example the date of first invoice is 02/04/15 (dd/mm/yy format). I can easily generate the invoice 150401 with formula =text(date,"yymm")&"01") which...
  5. M

    Count Dates on a ROW if the criteria in a corresponding COLUMN matches a specific value in another cell

    Hi All, I have two sheets that I am working with: Sheet 1: Has the cell I want to return the result in Has a Specific Identifier I need to be matched Sheet 2: Has a Column of multiple identifiers that is used to match the specific identifier on Sheet 1 Has a ROW of 6 unique dates for...

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