Number of days between past date and current date in Google spreadsheet

date google-sheets datediff
vkrams picture vkrams · Jan 6, 2013 · Viewed 98.5k times · Source

I want to calculate the number of days passed between past date and a current date. My past date is in the format dd/mm/yyyy format. I have used below mentioned formulas but giving the proper output.

=DAYS360(A2,TODAY())
=MINUS(D2,TODAY())

In the above formula A2 = 4/12/2012 (dd/mm/yyyy) and I am not sure whether TODAY returns in dd/mm/yyyy format or not. I have tried using 123 button on the tool bar, but no luck.

Answer

Matthew Clayton picture Matthew Clayton · Jan 9, 2016

The following seemed to work well for me:

=DATEDIF(B2, Today(), "D")

Related questions

How to format a JavaScript date

In JavaScript, how can I format a date object to print as 10-Aug-2010?

Read More
How do you get a timestamp in JavaScript?

How can I get a timestamp in JavaScript? Something similar to Unix timestamp, that is, a single number that represents the current time and date. Either as a number or a string.

Read More
How do I get the current date in JavaScript?

How do I get current date in JavaScript?

Read More