Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get relative row numbers in a range in Excel
  • Create hyperlink with VLOOKUP in Excel
  • How to get last row in text data in Excel
  • How to get last column number in range in Excel
  • How to get address of last cell in range in Excel

Data Analysis Examples

  • How To Insert and Customize Sparklines in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • Conditional Formatting Rules in Excel
  • How to combine 2 or more chart types in a single chart in Excel
  • Move chart to a separate worksheet in Excel

Data Validation Examples

  • Excel Data validation don’t exceed total
  • Excel Data validation only dates between
  • Excel Data validation must contain specific text
  • Excel Data validation with conditional list
  • Excel Data validation no punctuation

Display Days in month in Excel

by

This tutorial shows how to Display Days in month in Excel using example below.

To get the number of days in a given month from a date, you can use a formula based on the EOMONTH and DAY functions.

Worked Example:   Sum by month in Excel

Formula

=DAY(EOMONTH(date,0))

Explanation

In the example shown, the formula in cell B5 is:

=DAY(EOMONTH(B5,0))

How this formula works

The DAY function returns the day component of a date.  The EOMONTH function returns the last day of the month for a given date. So, in this formula EOMONTH first returns a date corresponding to the last day of the month, and then DAY returns the date value for that date.

Worked Example:   How to calculate nth day of week in month in Excel

By definition, the value returned by DAY is always equal to the number of days in the month, since the date supplied to DAY is always the last day.

Post navigation

Previous Post:

Get age from birthday in Excel

Next Post:

Count dates in current month in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to strip protocol and trailing slash from URL in Excel
  • TEXT function: Description, Usage, Syntax, Examples and Explanation
  • Get last name from name with comma — Manipulating NAMES in Excel
  • REPLACE, REPLACEB functions: Description, Usage, Syntax, Examples and Explanation
  • How to create email address with name and domain in Excel
  • How to calculate working days left in month in Excel
  • Get work hours between dates and times in Excel
  • Convert Excel time to decimal seconds
  • Convert decimal seconds to Excel time
  • WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation
  • YIELDDISC function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate compound interest in Excel
  • PRICEMAT function: Description, Usage, Syntax, Examples and Explanation
  • RECEIVED function: Description, Usage, Syntax, Examples and Explanation
  • COUPNUM function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles