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
Configuration: Windows XP Internet Explorer 6.0
Excel data from column to row Excel data in text need to change format to date Excel data validation from another worksheet Excel data validation text Excel execute macro on enter for range Excel filter data based on cell value Excel find and replace macro Excel macro if found then nothing Excel paste special macro How to copy excel data to a textfile using vba How to copy excel data to a textfile via vba How to create an excel data table for future value and precentage How to repeat formula in specified rows using macro in excel Importing data from excel to data warehouse Macro for sorting column excel in mac Macro to split data into 2 cells Update links macro excel Web query data extraction