Product
Features
All-in-one spreadsheet for teams
Rows AI
Your number crunching sidekick
Reporting
Stunning reports in minutes
Advanced Features
Extra magic for pros
Internal Tools
Build tools autonomously
Integrations
Seamless connections to your tools
Pricing
Templates
Community
Resources
Blog
Stories about spreadsheets and the people who build them.
Support Docs
Learn how to make the most out of Rows.
API Docs
The reference documentation for the Rows API.
Sign in
Sign up for free
Functions
LASTXMONTHS
Get the date interval for the last X months.
Parameter List
Syntax
LASTXMONTHS
(
months
)
months
The number of months prior to the current one.
Examples
Example 1
LASTXMONTHS(1) returns [2021-04-01;2021-04-30]
Example 2
LASTXMONTHS(3) returns [2021-02-01;2021-04-30]
Parameter List
Examples