Automatic Population

Z

Zach

On a spreadsheet where we enter issues that arise we enter the current date.
This is supposed to populate a column that tells us how many days the issue
has been on the list. It is not doing this anymore.
 
C

Chad

Assume your date of the issue is in cell A1 then:

=DAYS360(A1,TODAY())

This will return the # of days between the date in cell A1 and today.

-Chad
 
R

Roger Govier

Hi

DAYS360() is a financial function and will not return accurately the
number of days between two dates.

Use
=TODAY()-A1
where A1 holds the date when the issue arose
 
Top