Just use

=Today()-A1

A1 being the cell your date is in. Format the cell as a number and you will
get the number of days between the two dates. There is really no reason to
ever use Days360. Days are stored as the number of days from 1/0/1900
(1/1/1900 is equal to 1). You can not use any date before 1/1/1900 or after
12/31/9999.

"Brian" wrote:

I take a report from Crystal Reports and export it to excel. One of the
columns is a date field. In excel I inserted a new column and would like to
have the fields tell me how old the record is, in days. Rather than have to
type todays date into every field I wanted to refer to a field with todays
date, but I can't get the Days360 command to work like that. It seems that it
only works when both dates are present, and both are in "". Basically what I
did looks like this Days360(A4,B5). A4 is todays date and B5 is the record's
date. Is there a better way to do this?