TEXT function in Excel - extract month as a text stringĪn alternative way to get a month number from an Excel date is using the TEXT function: =MONTH("1") - obviously, returns number 4 too.=MONTH(DATE(2015,4,15)) - returns 4 corresponding to April.=MONTH(A2) - returns the month of a date in cell A2.This is the most obvious and easiest way to convert date to month in Excel. MONTH function in Excel - get month number from date Which one to choose depends on exactly what result you are trying to achieve. There are several ways to get month from date in Excel. How to get month number from date in Excel But look through the below examples and you will be amazed to know how many useful things it can actually do. =MONTH(TODAY()) - returns the number of the current month.Īt first sight, the Excel MONTH function may look plain. =MONTH(A1) - returns the month of a date in cell A1. In practice, instead of specifying a date within the MONTH function, it's more convenient to refer to a cell with a date or supply a date returned by some other function. For example, the formula =MONTH(DATE(2015,3,1)) returns 3 since DATE represents the 1st day of March, 2015.įormulas like =MONTH("") also work fine, though problems may occur in more complex scenarios if dates are entered as text. Where serial_number is any valid date of the month you are trying to find.įor the correct work of Excel MONTH formulas, a date should be entered by using the DATE(year, month, day) function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |