Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Lookup entire row in Excel
  • How to use Excel MMULT Function
  • How to use Excel ROW Function
  • Vlookup Examples in Excel
  • Two-column Lookup in Excel

Data Analysis Examples

  • How to calculate average last N values in a table in Excel
  • Error Bars in Excel
  • How to Sort by Color in Excel
  • How to combine 2 or more chart types in a single chart in Excel
  • Move chart to a separate worksheet in Excel

Data Validation Examples

  • Excel Data validation date in next 30 days
  • Excel Data validation exists in list
  • Excel Data validation specific characters only
  • Excel Data validation only dates between
  • How To Create Drop-down List in Excel

Display Date is same month in Excel

by

This tutorial show how to Display Date is same month in Excel using the example below.

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.

Worked Example:   How to calculate next scheduled event in Excel

 Formula

=MONTH(date1)=MONTH(date2)

Explanation of how this formula works

In the example shown, the formula in cell D6 is:

=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.

Worked Example:   Excel Data validation date in next 30 days
=MONTH(B6)=MONTH(C6)
=1=1
=TRUE

Same month as today

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())

Same month and year

To test that a date is the same month and year is another date, you can use;

EOMONTH(date1,)=EOMONTH(date2,)
Worked Example:   Get month from date in Excel

Post navigation

Previous Post:

Get day from date in Excel

Next Post:

Display Date is workday in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to Remove Leading Spaces in Excel
  • How to Separate Text Strings in Excel
  • Change Case: Uppercase, Lowercase, Propercase in Excel
  • Get position of 2nd 3rd and more instance of character in Excel
  • Convert Text to Numbers in Excel
  • How to show last updated date stamp in Excel
  • Convert time to time zone in Excel
  • WEEKDAY function: Description, Usage, Syntax, Examples and Explanation
  • Count holidays between two dates in Excel
  • Calculate retirement date in Excel
  • YIELDMAT function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYBS function: Description, Usage, Syntax, Examples and Explanation
  • AMORLINC function: Description, Usage, Syntax, Examples and Explanation
  • Tax rate calculation with fixed base in Excel
  • COUPDAYSNC function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles