Prev: Seperate dataNext: 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" 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 dataNext: Unusual Date Format