Enclosing the Date value formula for the Month Formula will convert the number to 1 Thus, we get the required output In this way, we can convert the name of the month to the number of the month Related Articles How to Add Months to a Date in Excel How to Calculate years between dates in ExcelMicrosoft Excel has several functions that allows manipulation of date and time, and one of them is MONTH(), which returns the month of a date in number ranging from 1 (for January) to 12 (December) Some Microsoft Office Excel users may prefer the month to be shown or displayed as month name in text instead of number, in the form of January, February, March andUse " m " if you want to display the month number without a leading 0 and " mm " if you want to display it with a leading 0 for single digits So, to display the month number corresponding to the date in cell , you can incorporate the appropriate format string into the TEXT function as follows =TEXT (, "mm") Or
Display The Month Name With A Formula In An Excel Report
