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.

Try restoring your field with the DAYS360 function.

Hope this helps,
-Chad

"Zach" wrote:

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.

How?

"Chad" wrote:

Try restoring your field with the DAYS360 function.

Hope this helps,
-Chad

"Zach" wrote:

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.

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


"Zach" wrote:

How?

"Chad" wrote:

Try restoring your field with the DAYS360 function.

Hope this helps,
-Chad

"Zach" wrote:

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.

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

--
Regards

Roger Govier


"Chad" wrote in message
...
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


"Zach" wrote:

How?

"Chad" wrote:

Try restoring your field with the DAYS360 function.

Hope this helps,
-Chad

"Zach" wrote:

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.