Product
Features
All-in-one spreadsheet for teams
Everyday Tasks
Upgrade your spreadsheets
Reporting
Stunning reports in minutes
Advanced Features
Extra magic for pros
Data Enrichment
All your data in one place
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.
Discord
Our spreadsheet community on Discord.
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.
Standard
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