Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting dates to get hours... but I want to skip weekends | Excel Discussion (Misc queries) | |||
Subtracting dates? | Excel Worksheet Functions | |||
Subtracting dates: 8/31/05-8/1/05? | Excel Discussion (Misc queries) | |||
subtracting dates to get a age | Excel Discussion (Misc queries) | |||
Dates Subtracting dates. | Excel Discussion (Misc queries) |