Skip to content

Instantly share code, notes, and snippets.

@gubatron

gubatron/Google Sheets - Days of a month

Created November 1, 2020 21:59
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 gubatron/146d5c78e7c98e0680b85bab4a5842a8 to your computer and use it in GitHub Desktop.
Save gubatron/146d5c78e7c98e0680b85bab4a5842a8 to your computer and use it in GitHub Desktop.
Download ZIP
Calculate the number of days in a month in Google Sheet.
Raw
Google Sheets - Days of a month
If cell `B1` had a date indicating the first of the month as in: `=11/1/2020`
To get the number of days of that month you do:
`=DAYS(EOMONTH(B1,0),B1)+1`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment