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?

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?

Why use Days360, and why not use TODAY() in the formula

=TODAY()-A1

--

HTH

RP
(remove nothere from the email address if mailing direct)


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

Yes, thank you. The post ahead of your said the same thing. I tried it and it
works great!

Thanks.



"Bob Phillips" wrote:

Why use Days360, and why not use TODAY() in the formula

=TODAY()-A1

--

HTH

RP
(remove nothere from the email address if mailing direct)


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