We have a client that has start dates in one colums and finish dates in
another column.
They need to produce information that shows the difference in weeks and days.
Is it possible for this to be done so that the weeks are shown in one column
and days are shown in another column.
If so a formula would be appreciated.
Also they have been inserting current information for the last year in
number format eg 12.12.06.
Is it possible to simply convert all of this to dates so that they can find
the difference or do they have to manually input all information again as
dates.

Thanks

JK