My worksheet has a column#3 of the number of days, produced by subtracting date in column1 from date in column2. Some on this forum helped me with getting this done. The column contains about 30 rows, and shows as a number representing the number of days. I want to use the data here in Column3 to determine the interest on a loan made for each of these dates. When I try to use the loan amount for each date times a column of daily interest amount, .005/365, times the number of days column, the result shows as a date. How do I make the number of days showing from this column3 available to use in my calculation? What do I do to copy the data, not the formula? Thanks so much.