google sheetsgoogle-sheets-dates
I'm using a Google Spreadsheet to perform calculations and I'd like to do some simple date math. For example,
TODAY() add 7 days.
I don't see any functions to do it and some quick stabs in the dark didn't pan out.
Does anyone know if this is possible?
I use this formula:
=day(eomonth(today(),0))
You'll have to replace today() with a date or a cell containing a date in the month for which you want the total number of days.
Create a filter view with filter by condition "Custom formula is", =sum(C2:F2). It does not matter which column the filter is placed at.
The filter takes place starting with the second row (header row is not filtered). Therefore, the custom formula should be written as it will be applied to the second row; the references will be automatically remapped for other rows.
If the value of a formula is 0, the row is omitted from the view. If it is anything else, the row remains in the view.
Best Answer
You can add days to a date in a Google spreadsheet like this:
Works with TODAY() as well: