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

 

[NTownend]

Sorry that doesnt work think it has something to do with the today function it just says the formula is volatile

 

[Fluff]

The Today function is volatile, but it should still work.

 

[NTownend]

No luck, when i look into the formula and break it down it just returns the start date in excel 01/01/1900?

 

[Fluff]

Do you have the =0 at the end of the formula as it should only return True or False.

 

[NTownend]

Yes i do but when i look into the formula its returning a date year ending 1900 and its showing as true because it doesnt = todays date or if i change any of the dates in the range so that it should return a false it doesnt because the base date is wrong if that makes sense.

Book1.xlsx
	A	B	C	D
1	PAYMENT_DATE	PAYMENT_DATE2	current month	Column3
2	17-Aug-22	17-Sep-22	02-Sep-2022
3	04-Aug-22	04-Sep-22	TRUE	TRUE
4	30-Aug-22	30-Sep-22
5	18-Aug-22	18-Sep-22	I want it to check the month in the range of column A against the month in cell D1 and return true or false, if any of the dates in the range do not equal the relevant month then I want it to return a true or false
6	05-Aug-22	05-Sep-22
7	17-Aug-22	17-Sep-22
8	17-Aug-22	17-Sep-22
9	12-Aug-22	12-Sep-22
10	18-Aug-22	18-Sep-22
11	05-Aug-22	05-Sep-22
12	18-Aug-22	18-Sep-22
13	16-Aug-22	16-Sep-22
14	26-Aug-22	26-Sep-22
15	04-Aug-22	04-Sep-22
16	16-Aug-22	16-Sep-22
17	09-Aug-22	09-Sep-22
18	11-Aug-22	11-Sep-22
19	31-Aug-22	12-Sep-22
20	31-Aug-22	13-Sep-22
21	31-Aug-22	14-Sep-22
22	31-Aug-22	15-Sep-22
23	31-Aug-22	16-Sep-22
24	31-Aug-22	17-Sep-22
25	31-Aug-22	18-Sep-22
26	31-Aug-22	19-Sep-22
27	31-Aug-22	20-Sep-22
28	11-Aug-22	11-Sep-22
29	04-Aug-22	04-Sep-22
30	01-Aug-22	01-Sep-22
31	26-Aug-22	26-Sep-22
32	10-Aug-22	10-Sep-22
33	15-Aug-22	15-Sep-22
34	10-Aug-22	10-Sep-22
35	18-Aug-22	18-Sep-22
36	25-Aug-22	25-Sep-22
Sheet2

Cell Formulas
Range	Formula
C2	C2	=TODAY()
C3	C3	=SUM(--MONTH($A$2:$A$36)<>MONTH(TODAY()))=0
D3	D3	=SUM(MONTH($B$2:$B$36)<>MONTH(TODAY()))=0

 

[NTownend]

sorry typo in spreadsheet above it should read cell c2

 

[Fluff]

Both the formula you posted are returning true/false not a date, which is what you said it was returning.
Also neither of them are the formula I posted which was

=SUM(--(MONTH($A$2:$A$36)<>MONTH(TODAY())))=0

 

[NTownend]

ok i am confused i didnt say it was returning a date i said when i actually broke the formula down the today function was showing a date ending in year 1900, i also cant see the difference between your formula and the one i just posted, sorry for the confusion,
All i want it to do is look at the months in column A or B (as examples) and tell me if they all match the current month in cell C2, so if there is one date in column A or B that is not Aug/Sep, in this example, then i want it to tell me that in the formula result , i hope this makes more sense thanks

 

[Fluff]

In that case use

=SUM(--(MONTH($A$2:$A$36)<>MONTH(C2)))=0

 

[NTownend]

SOP57307145_1_1
SOP57307145_1_1
SOP57307145_2_1
SOP57307145_2_1
SOP57307145_2_2
SOP57307145_2_2
SOP57307152_1_1
SOP57307152_1_1
SOP57307152_2_1
SOP57307152_2_1

hi next problem i have a multiple lines in a column and i want to seperate these out, so in the example above i want to get rid of the first 3 characters "SOP" and then separate the next 3 sets of data into 3 columns so i would get

57307145	1	1
57307145	1	1

with the conditions that all three columns could have a different total number of characters in each string i.e

SOP5730714_12_5
SOP573071456_1_15

and so on. text to columns is not workable as i want to automate 1000's of lines
cheers