Check a range of dates fall within a specific month and return a true value

[NTownend]

I have a range of dates in one column for say the month of August and i want to check all the dates in that column to ensure they all fall within that month and return a true or false value in one cell only

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[NTownend]

Hi I have updated my details as requested i am using office 365 on windows 10 64-bit version hope this helps

 

[Fluff]

Thanks for that
How about

=SUM(--(MONTH(A2:A18)<>8))=0

 

[NTownend]

Brilliant thanks been racking my brain for ages

 

[Fluff]

Glad to help & thanks for the feedback.

 

[NTownend]

and what if i want to have a formula that checks the data in that column month on month without me having to change the dates. so the cell that returns true/false will look at the same range of data but compare it to say the current month or previous month?

 

[Fluff]

You could put the month number in another cell & refer to that.

 

[NTownend]

So something that looks like this =SUM(--(MONTH(A2:A18)<>B1))=0, where B1 = current month?

 

[Fluff]

That's right.
If you just want to compare the dates to the current month could also use

=SUM(--(MONTH(A2:A18)<>Month(Today())))=0