If same Month & Year, return a value skipping Blank cells

[colzre]

Hello Experts!


I am trying to build a formula where if same month is a on both cells (column E and I), this will return as 1.

It does work when there is a date on each cell however when cells are blank, I would like this to return as 0 which is same value as when cells don´t match.

Row 7 works and row 28 still need to return as 0, rather than 1 since it´s blank.

Any advice?

DATABASE TURNOVER REPORT PANORAM HOTELS 2024 - Copy.xlsx
	E				I							P
6	Month				START DATE							ENTRIES
7	Jun-2024				Jan-2024							0
28												1
bbdd

Cell Formulas
Range	Formula
P7,P28	P7	=IF(MONTH(I7)&YEAR(I7)=MONTH(E7)&YEAR(E7),1,0)

I appreciate your help beforehand!

John

 

[Fluff]

How about

=IF(OR(E7="",MONTH(I7)&YEAR(I7)<>MONTH(E7)&YEAR(E7)),0,1)

 

[felixstraube]

Try this in P7 and copy down:

=(E7<>"")*(MONTH(E7)=MONTH(I7))*(YEAR(E7)=YEAR(I7))

 

[colzre]

Thank you both!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Scott Huish]

Just throwing this out here:
=(EOMONTH(E7,0)=EOMONTH(I7,0))*(COUNT(E7,I7)=2)