Date is same month

An excel formula to date is same month

Related Functions

Sponsored Link

 Date is same month
=MONTH(date1)=MONTH(date2)

If you need 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.

How the formula works

In the example, the formula in cell D6 contains this formula:

 
=MONTH(B6)=MONTH(C6)

In this case, Excel extracts the month from the date in cell B6 as a number, and the month in the cell C6 as a number, then tests for equivalency using the equal sign. Both dates are in January, so the formula is solved as follows and returns TRUE.

 
=MONTH(B6)=MONTH(C6) =1=1 =TRUE

If you need to test a date to see if has the same month as the current date (today), you can use this formula:

 
=MONTH(date)=MONTH(TODAY())

Sponsored Link

0 votes. 0 / 5