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

I have a Lotus Notes database that exports the dates shown as 070104 (yymmdd) but as text. I need to calculate how many days the project is overdue by subtracting the date that is exported from today's date. Is there a way this can be done with this format? Currently I have another column set up in Excel where I manually change the date to 01/04/07 and the next column formula subtracts this date from today's date to give me the number of days past this goal date the project is open.

I am running Excel 2000

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.