[最も共有された！ √] excel return month name from date 115452-Excel vba return month name from date
UPDATE Setting date format nationality didn't helpUsing the TEXT Function to Convert a Date to Month Name in Excel Let's say you have the date in cell You can then use the TEXT function to extract the month name from the date as follows =TEXT (MONTH (),"mmmm") For example, 5/8/11 will return 5 when using the month function, and return to 05 or the month name when using the text function To convert a date to the month number with 2 digits (eg, 05), please copy the formula and change the cell name =Text(,"MM") Excel Formula Get Month Name From Date Exceljet Excel vba return month name from date