Excel data extraction macro needed

 Umer -
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?



3 replies

Registration date
Sunday August 17, 2008
Last seen
January 13, 2009
hey there,

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

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

CCM 2942 users have said thank you to us this month

HI Andy, thank you for the Message. I will definitely try this out
Why not just use the formula =[Latest date cell]-[Earliest date cell]?
I hv exactly the same problem as theo.Someone plz help me with this.thanks