Date formula needed

[Victoria1]

Hi All,

I'm struggling with a formula.

I have 2 date fields:

Cell D1 - 10/1/19
Cell E1 - 11/1/19

On another tab in the workbook (Summary) I have Months listed in column A;
January
February
March
etc. through December

I'd like to be able to allocate a "1" to the Summary tab, Column B counting each time a date falls within that month.

For example:
Cell D1 - 10/1/19
Cell D2 - 11/1/19

Cell E1 - 11/1/19
Cell E2 - 12/15/19

Summary Tab would display
October - 1
November - 2
December - 1

Any ideas on the formula I can utilize? I'm thinking it's an IF(AND( but can't get there.

Thanks in advance!

 

[James006]

Hi,

As long as January is located in A1, February in A2, etc ...

In your sheet ' Summary ', in cell B10, you can following Array Formula:

=SUM(IF(MONTH(Sheet1!$D$1:$E$2)=ROW(),1,0))

to be copied to all other rows ...

Hope this will help