How to Extract Just Month and Day from a Date in Excel Using Formula

Learn the simple Excel formula to display only the month and day from a full date using the TEXT function.

2,900 views

To extract just the month and day from a date in Excel, use the TEXT function: `=TEXT(A1, "MM-DD")`. This formula assumes your date is in cell A1. MM represents the month and DD represents the day. This will format the date as a text string displaying only the month and day.

FAQs & Answers

  1. How do I extract only the month and day from a date in Excel? You can use the formula =TEXT(A1, "MM-DD") where A1 contains your date, to display just the month and day.
  2. Can the TEXT function be used to format dates differently in Excel? Yes, the TEXT function allows you to format dates in various ways by specifying format codes like "MM/DD", "DD-MM", or "MMMM DD".
  3. Will the result of =TEXT(A1, "MM-DD") still be a date value? No, the result is a text string showing the month and day, so it won’t behave as a date value in calculations.

Watch More

For more Excel date formatting tips, check out related tutorials on extracting year, month, or day individually, and how to customize date formats effectively in Excel.

  1. How to Extract and Display Month in Excel Calendar Using Formulas Learn the Excel formulas to display month names and numbers from dates in your calendar with easy-to-use functions.
  2. How to Use the MONTH Formula in Excel to Extract Month Numbers Learn how to extract month numbers from dates in Excel using the MONTH formula with this step-by-step guide.
  3. How to Use the DAY Formula in Excel to Extract Day from a Date Learn how to use Excel's DAY() function to extract the day of the month from a date with a simple formula example.
  4. How to Convert Days to Months in Excel Using a Simple Formula Learn the easy Excel formula to convert days to months by dividing days by 30 for quick and approximate monthly values.
  5. How to Calculate Number of Days in a Month Using Excel Formula Learn the Excel formula to find the number of days in any month using EOMONTH and DAY functions.
  6. How to Calculate the Number of Days in a Month in Excel Using a Simple Formula Learn the Excel formula to calculate the total days in any month with ease using =DAY(EOMONTH(date,0)).
  7. Understanding the Excel DATE Formula for Date Creation Learn how to use the =DATE function in Excel to format dates consistently.
  8. How to Calculate the Number of Days in a Month Using Excel Formula Learn the simple Excel formula =DAY(EOMONTH(A1,0)) to find the exact number of days in any month based on a date in cell A1.
  9. Understanding the DAY Function in Excel: How to Extract Days from Dates Learn how to use the DAY function in Excel to extract the day from dates efficiently.
  10. How to Calculate the Number of Days in a Month Using Excel Formula Learn the simple Excel formula =DAY(EOMONTH(A1,0)) to return the number of days in any month based on a given date.
  11. How to Count Days in a Month in Excel Using the EOMONTH Function Learn how to count the exact number of days in any month in Excel with the EOMONTH function and simple formulas.
  12. How to Calculate the Number of Days in a Month Using Excel Formula Learn how to calculate the number of days in any month with Excel using the EOMONTH and DAY functions formula.