Excel data extraction macro needed

Closed
Theo - Sep 15, 2008 at 04:14 AM
 Umer - Feb 19, 2009 at 09:16 PM
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

andy6776
Posts
17
Registration date
Sunday August 17, 2008
Status
Member
Last seen
January 13, 2009
23
Sep 15, 2008 at 06:49 AM
hey there,

just try to see the help about macros on the forum itself you might find what you are in search of
19
HI Andy, thank you for the Message. I will definitely try this out
0
Why not just use the formula =[Latest date cell]-[Earliest date cell]?
5
I hv exactly the same problem as theo.Someone plz help me with this.thanks
4