View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Heine Heine is offline
external usenet poster
 
Posts: 49
Default changing date formats

hello everybody

I have thousands of rows looking like this:

20060505
20070302
20050708

etc.

How can I change these to date formats so I can calculate the number
of days between these dates and another row of dates?

Any ideas?

regards
Heine