vep temp
Reputation: 267
Compare months in excel
how to compare months in excel, for example I have Nov in cell A1 and Nov as well in cell B1, so if those are equal will display 1 else diplay 0.
Upvotes: 1
Views: 9639
Answers (1)
barry houdini
Reputation: 46371
If those are just text values try
=IF(A1=B1,1,0)
or are they actual dates formatted to show the month? In which case try
=IF(MONTH(A1)=MONTH(B1),1,0)
Upvotes: 3
Related Questions
- If year and month match then make calculation
- Excel, two columns, date comparison, specific month
- Compare month and day (not year) in Excel
- Trying to compare dates differences that are over a month apart
- Comparing dates on excel
- Test for change in month from list of dates
- Excel VBA Comparing between a given date and (given date - 2 months)
- Comparing values in Excel between YTD Monthly reports
- Compare dates of two cells in excel
- Date comparison in excel question