I have been given an Excel file with that contains the installation date for
10,000 items. I need to determine the number of days/years these items have
been in-service. I know the appropriate formula to determine the number of
days between two dates; my problem is the installation date is formatted as
yyyymmdd. So, for example, today appears as 20070521. How can I convert
this is appear as 5/21/07, or some legitimate date format. Thanks in advance
for your help.