There's no Excel function to calculate the first day of the month, but the EOMONTH function will calculate the last day of a month To find the first day of a month we will calculate the last day of the previous month and add one day Here let's find the last day of the previous month 1 = EOMONTH(, 1) Now let's add one day to the Uѕіng the Excel TEXT function іѕ thе еаѕіеѕt way to extract month name from date We can refer a valid dаtе value with any valid formats in Excel to thіѕ function, аnd іt rеturns thе month name as per the custom format we specify, like " mmm " or " mmmm ", such as;Below are the steps to do this Select any cell in the dataset Click the Data tab In the Get & Transform Data tab, click on From Table/Range In the Power Query editor that opens up, rightclick on the Date column header Go to Transform >> Month >> Name of Month
8 Ways To Extract The Month Name From A Date In Excel How To Excel
