Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Excel data extraction macro needed [Closed]

Report
-
 Umer -
Hello,
Hie .I am working on a project in which l have to compare dates in excel and enter the difference (in days)in time in a separate column .l am looking for a macro which can extract data from text ie if the end date of a task in a project is say 2008/08/10 i n a previous project review then it becomes say 2008/10/12 .l need to write a macro which can tell me the difference in figures ie it subtracts the earlier date value from the latest one to give me the time difference in days.Is it possible? Is there anyone who can assist?

Thanx

Theo

3 replies

Answer 1 / 3
Posts
17
Registration date
Sunday August 17, 2008
Status
Member
Last seen
January 13, 2009
 23
hey there,

just try to see the help about macros on the forum itself you might find what you are in search of
19
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Report

HI Andy, thank you for the Message. I will definitely try this out
Answer 2 / 3

Why not just use the formula =[Latest date cell]-[Earliest date cell]?
Answer 3 / 3

I hv exactly the same problem as theo.Someone plz help me with this.thanks
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!