00:00 Convert a date into the month number
00:07 Useful if you want Excel to match the month and ignore the day and year
00:27 Extract the month number from the date

It can be important to extract the month number out of an Excel date. This helps when building a formula that says something like, if the month is January, then do something. By extracting the month number you can build formula that refer to numbers instead of worrying about how the month name has been spelled (January versus Jan etc).

свернуть