Prev: Seperate data
Next: Unusual Date Format
From: Grey Old Man on 21 Apr 2010 03:37
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.



From: "David Biddulph" groups [at] on 21 Apr 2010 03:52
=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" <GreyOldMan(a)discussions.microsoft.com> wrote in message
news:AB45D038-6494-47C2-BDB9-7E12F4373DBB(a)microsoft.com...
> 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.
>
>
>

 | 
Pages: 1
Prev: Seperate data
Next: Unusual Date Format