G
Grey Old Man
I am writing an Excel 2002 template. I am importing two columns of dates
(date from and date to) 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 two dates, shown as a number
of weeks rounded down to the nearest whole number.
Any help would be appreciated.
(date from and date to) 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 two dates, shown as a number
of weeks rounded down to the nearest whole number.
Any help would be appreciated.