Skip to main content
Skip table of contents

Getting the Days per Month/Year with DROPLEVEL() and EXPAND()

By combining DROPLEVEL(EXPAND()), you can easily get the days in a month

By using


you get the days in a month. This holds true even for leap years and other irregularities.

Similarly, by using


you get the number of days in each quarter.

Finally, by using


You can get the number of days in each year.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.