# How To Use Eo Month ISOWeekNum Network Days Intl And Month Function In Excel Spread Sheet

• Formulas

## FAQs

• Get the month number from the date using the MONTH function in Excel.
• Consider the following scenario: The formula =MONTH(A2) yields the month of a date in cell A2. =MONTH(DATE(2015,4,15)) produces the number 4 for April.

There aren't any breaks in between. The weekend, on the other hand, occurs on Friday and Saturday. As a result, the formula to utilise is =NETWORKDAYS. INTL(A2,B2,7).

The ISOWEEKNUM function returns an ISO-compliant week number. Following ISO 8601, weeks start on Monday and the week number 1 is assigned to the first week of a year that includes a Thursday.

This is the simplest and most obvious way to convert a date to a month in Excel. Consider the following scenario: The formula =MONTH(A2) yields the month of a date in cell A2. =MONTH(DATE(2015,4,15)) produces the number 4 for April.

## Recommended Courses

### Share With Friend

Have a friend to whom you would want to share this course?   ######    