WHYS.video

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.

Published

Video transcript

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.

Questions and 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.

Related questions

Continue exploring

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.