View Single Post
  #1   Report Post  
Brian
 
Posts: n/a
Default subtracting dates

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?