Google Sheets – How to Automatically Calculate ‘Days Since’

dategoogle sheets

I have a spreadsheet with several columns and one of them is for date (column D). How do I make the next column (E) automatically display the days passed from date in D until now on open?

I have tried with

=DAYS360(D1,NOW())

but it displays #VALUE!

Best Answer

Use the formula =IF([cell on same row in D column] <> "", today()-[cell on same row in D column], "")

So in D2 (for example):

=IF(D2 <> "", TODAY()-D2, "")

TODAY() returns the current date. The current date minus the specified date equals the days passed between the dates.

The code above means "If D2 is not empty set current cells value to days since else set it to be empty"

Related Solutions

Google-sheets – Spreadsheet to calculate weekly increase

Your calculation of "This time" / "Last time" expressed as a percentage (by the formatting) is essentially correct, except it isn't working out the increase.

So if it was 10 minutes yesterday, and 10 minutes today, that means you did 100% of the time you did yesterday. This is what you are calculating now.

So (Today / Yesterday) - 1 will give you the increase (when expressed as a percentage). The subtracting 1 removes the original amount.

For example, if it was 10 minutes yesterday, and 11 minutes today, then that is

11 / 10 = 1.1   
1.1 - 1 = .1
.1 * 100 = 10%

If you did 9 minutes today and ten yesterday:

9 / 10 = .9 - 1 = -.1 * 100 = -10%

Google-sheets – How to automatically refresh date in Google spreadsheet published to the web

You can set the interval for recalculation of the spreadsheet in the Spreadsheet settings which you can find in the File menu.

There you can set it to recalculate on change and/or every minute or hour.

Through this, functions like Now() should be updated automatically in the interval you set.

Best Answer

Related Solutions

Google-sheets – Spreadsheet to calculate weekly increase

Google-sheets – How to automatically refresh date in Google spreadsheet published to the web

Related Topic