I am writing an Excel 2002 template. Two columns of dates (date from and date
to) are both imported from an external source. The date format is 'cyymmdd'
so today would be '1100421'. The cells are formatted as text.

I need to calculate the difference between the dates shown as a number of
weeks, rounded down to the nearest whole number.

Any help would be appreciated.

=INT((DATE(LEFT(A3,3)+1900,MID(A3,4,2),RIGHT(A3,2) )-DATE(LEFT(A2,3)+1900,MID(A2,4,2),RIGHT(A2,2)))/7)
--
David Biddulph


"Grey Old Man" wrote in message
...
I am writing an Excel 2002 template. Two columns of dates (date from and
date
to) are both imported from an external source. The date format is
'cyymmdd'
so today would be '1100421'. The cells are formatted as text.

I need to calculate the difference between the dates shown as a number of
weeks, rounded down to the nearest whole number.

Any help would be appreciated.