# formula needed - 2 dates fields and summarizing to count/month

1. ## formula needed - 2 dates fields and summarizing to count/month

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.

2. ## Re: formula needed - 2 dates fields and summarizing to count/month

its relatively straight forward, as long as your months are dates and not text, but really an attachment with some sample data and expected results will get you a better answer

the answer will be arounf countifs or sumproduct.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

3. ## Re: formula needed - 2 dates fields and summarizing to count/month

=SUMPRODUCT((TEXT(Dates!D\$1:D\$1000,"mmmm")=Summary!D1)+(TEXT(Dates!B\$1:B\$100,"mmmm")=Summary!D1))
copy down the column

where your date ranges are ona sheet called Dates

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1