Skip to content

Instantly share code, notes, and snippets.

@simonbreton

simonbreton/Last 6 months spreadsheet formula (blog article)

Last active October 2, 2018 16:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save simonbreton/7cd19c68185eda0df3bc04949e355ac6 to your computer and use it in GitHub Desktop.
Save simonbreton/7cd19c68185eda0df3bc04949e355ac6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Last 6 months spreadsheet formula (blog article)
=arrayformula(if(A2:A<>””,if(A2:A>=EDATE(today(),-6),”last 6 months”,”older than last 6 months”),””))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment