I need to calculate how many days are left from today to a certain date in the future in Google Sheets.
How can I do that?
There are two possible options for you to consider.
"28/06/2015"-TODAY())
DATEDIF(TODAY(), "28/06/2015", "D")
Todays date is: 28/10/2014
. The result will be an integer (243).
Make sure to format the outcome as a number and not a date. If you choose the NOW()
formula, you introduce a time component. This will break up the calculation and show decimals.
Found the answer, this formula will do it:
=round(abs("2014-01-08"-NOW()),0)
Where "2014-01-08"
is the date in the future.