subtract dates in Excel, but one is not in date format.

I tried both suggestions. The first one returns #Value! in the cell and the second on returns #Num! in the cell.

In all cases you must change the cell reference in the formula to the cell in your worksheet

I did that also. When I click on the = mark beside the address window. The result is showing in the window correctly, but in the cell it is not showing the same results.

I think my problem has something to do with the way that Lotus Notes exports the information. I tried both formulas in another Excel workbook and they worked.

I tried formatting the Lotus Notes export information and can not get the formulas to work in it.

Thanks for the info though. I just have to find how to make it work with the export.