Learn English Basics - Days and Dates. Days and Dates in English. Days of the week | Months of the year | Dates | Prepositions | What to say. Interesting Stuff . A year is divided into 12 months in the modern-day Gregorian calendar. Each month has either 28, 30, or 31 days during a common year, which has days. The Gregorian calendar consists of the following 12 months. To get the date of the last day of the month in Excel, use the EOMONTH (End of Month) function. TEXT function in Excel - extract month as a text string. To do this, you can use any of the following formulas: B15 Where E2 is the month number. When it comes to the first day of the month, there is more than one way to get it. If you'd rather not add a date of the month column to your Excel sheet, no problem, you can do without it.