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?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
There are two possible options for you to consider.
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:
"2014-01-08" is the date in the future.