Formula Bug in MONTH()

Example:
=MONTH(DATE(2020,4,30)+1) should be 5, not 4

Also:
=MONTH(DATE(2020,3,1)) should be 3, not 2

We accept the bug. We’re tracking this internally as issue #001568 and will add to this thread when we have updates to share.

This has been resolved with the latest product update on 30/01/2021.

1 Like

I ran a test of the MONTH() function for dates 1/1/2019 to 2/8/2023 (1500 rows) and it seems to be working correctly now. Thank you!

1 Like