Excel Formula to get Number of Days in a Month

It seems Excel still can’t tell me the days in a particular month.

The following formula works, though:

=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)

Obviously, A1 has to have a date in it.

Works like a charm:

Example: Days in a Month in Excel

Cube Root in OpenOffice

OpenOffice.org doesn’t seem to have any built-in functions for cube roots, but there’s an easy workaround. To find the nth root, use powrs to the nth fraction. Probably easier to illustrate than to explain with my rusty math skills. ;)

I mean this:

Example: Cube Root in OpenOffice

You need to use the brackets because otherwise the power would take precedence over the division.