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