Date conversion & calculation

**jmh** · 05-22-2007, 01:38 AM

Hi!

I've been following the discussion here for a while, but this is my first post.

I wonder if someone could advice a simple way to convert the following date format into format which Excel understands:

Thu May 11 14:57:22 EEST 2006
Tue May 23 22:05:53 EEST 2006 etc.

I'd need to convert this into format like dd.mm.yyyy hh:mm:ss. The timezone (EEST) and weekday can be ignored.

Another questions is then related to calculation of dates. How can I calculate for example how many weeks (or days) is the difference between now and for instance Thu May 11 14:57:22 EEST 2006 (which is first converted to a format which Excel understands as a date)?

Thanks a lot for your help!

**Paul** · 05-22-2007, 02:08 AM

This should get you the first answer:

Please Login or Register  to view this content.

Then, to determine the number of days between two dates, you can use DATEDIF, like so:

=DATEDIF(<earliest date>,<latest date>,"d")

where <earliest date> is the earlier of the two dates and <latest date> is the later of the two dates. If A1=May 11, and A2=May 15, you would put:

=DATEDIF(A1,A2,"d")

For more on DATEDIF, see http://www.cpearson.com/excel/datedif.htm

You could even do

=DATEDIF(A1,Now(),"d")