To test two dates to see they both have the same month, you can do so with a simple formula that uses the MONTH function. In the example shown, the formula in cell D6 is: =MONTH(B6)=MONTH(C6)
April 14, 2025 · 1 min · 15 words · Kimberly Schwartz
Both dates are in January, so the formula is solved as follows and returns TRUE.