Unusual Date Format

G

Grey Old Man

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.
 
D

David Biddulph

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unusual Date Format 0
Display weeks from a Milestone 0
Conditional formatting with dates 7
Dates, And Their Corresponding Numbers: How To Show ? 0
Remove date format? 3
Calculate date so many days before/after current date. 4
Excel does not accept text format! 0
Find the number of weeks using an array 0

Top