EOMONTH
Supported, behaves as documentedCategory: Date and time · Last tested 2026-07-04
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel | Yes | Not yet | n/a |
| Google Sheets | Yes | Not yet | n/a |
| LibreOffice Calc | Yes | Yes (24.2.7.2, 2026-07-04) | Supported, behaves as documented |
Executed test cases
LibreOffice Calc 24.2.7.2 (tested 2026-07-04)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =EOMONTH(DATE(2024,3,15),0) | months=0 returns the end of the SAME month as the given date | 45382 | 45382 End of March 2024 = 2024-03-31 = serial 45382 |
Matched |
| =EOMONTH(DATE(2024,3,15),1) | Positive months argument moves forward to the end of a future month | 45412 | 45412 End of April 2024 = 2024-04-30 = serial 45412 |
Matched |
| =EOMONTH(DATE(2024,3,15),-1) | Negative months argument moves backward to the end of a past month | 45351 | 45351 End of February 2024 (a leap year) = 2024-02-29 = serial 45351 |
Matched |
| =EOMONTH(DATE(2024,12,15),1) | Positive offset that also crosses a year boundary | 45688 | 45688 End of January 2025 = 2025-01-31 = serial 45688 |
Matched |
Docs & syntax
- Excel: official documentation
- Google Sheets: official documentation
- LibreOffice Calc: official documentation