Count of months against current month

Hi there -

I'm trying to work out a formula that will check the current month (from today's date) and see whether there are any occurrences of that in other sheets, in a range.

I've uploaded an example of the data I'm working with. In sheets A,B,C & D will be a list of dates and on the Check sheet I want to have a list of the sheets and a count of how many rows have the same month / year combination. I think it will be something like =COUNTIF(A!G2:G8,IF((MONTH(B2)+YEAR(B2))=(MONTH(A!G2)+YEAR(A!G2)),"Yes","No")) but I know the end of it is wrong.

This workbook will be opened at the beginning of each month and someone will check from the Check sheet whether they need to do something this month.

Example.xlsx

Thanks in advance!

Hi,

Welcome to the Forum.

Try the following formula in B5:
=COUNTIFS(A!G:G,">"&EOMONTH($B$1,-1),A!G:G,"<="&EOMONTH($B$1,0))

In B6:
=COUNTIFS(B!G:G,">"&EOMONTH($B$1,-1),B!G:G,"<="&EOMONTH($B$1,0))

B7:
=COUNTIFS('C'!D:D,">"&EOMONTH($B$1,-1),'C'!D:D,"<="&EOMONTH($B$1,0))

B8:
=COUNTIFS(D!D:D,">"&EOMONTH($B$1,-1),D!D:D,"<="&EOMONTH($B$1,0))

See the attached file.

Perfect! Thank you very much.

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.