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

DROPLEVEL(EXPAND(1,“Day”),”Day”)

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

Similarly, by using

DROPLEVEL(EXPAND(1,“Day”),“Month”)

you get the number of days in each quarter.

Finally, by using

DROPLEVEL(EXPAND(1,”Day”),”Quarter”)

You can get the number of days in each year.


Contact

You may contact the Valsight Customer Support via:

+49 30 46799042

support@valsight.com

Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .

*Except Public holidays in Berlin, Germany.

JavaScript errors detected

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

If this problem persists, please contact our support.