From: Pat Briggs on 18 May 2010 12:30 I have two columns one labeled start date, the other Date Completed. I have a third column where I need to display how many days it took to complete the process from start to finish. Do I need a macro? I have no idea how to format the third column to calculate the days between the other two. From: Mike H on 18 May 2010 12:36 Hi, Try this un-documented formula =DATEDIF(A1,B1,"d") For help on this formula look here http://www.cpearson.com/excel/datedif.aspx -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Pat Briggs" wrote: > I have two columns one labeled start date, the other Date Completed. I have > a third column where I need to display how many days it took to complete the > process from start to finish. Do I need a macro? I have no idea how to > format the third column to calculate the days between the other two. From: Ms-Exl-Learner on 18 May 2010 12:37 Assume that in A2 cell you are having the START DATE and in B2 cell is the END DATE. Copy and paste the below formula in C2 cell =IF(AND(A2<>"",B2<>""),DATEDIF(A2,B2,"D"),"") Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Pat Briggs" wrote: > I have two columns one labeled start date, the other Date Completed. I have > a third column where I need to display how many days it took to complete the > process from start to finish. Do I need a macro? I have no idea how to > format the third column to calculate the days between the other two. From: T. Valko on 18 May 2010 12:45 Just subtract the start date from the end date. A1 = start date = 1/1/2010 B1 = end date = 1/31/2010 =B1-A1 Format as General or Number Result = 30 Copy down as needed. -- Biff Microsoft Excel MVP "Pat Briggs" wrote in message news:41762A52-2568-453F-836B-6BFBF03DC50F(a)microsoft.com...>I have two columns one labeled start date, the other Date Completed. I >have > a third column where I need to display how many days it took to complete > the > process from start to finish. Do I need a macro? I have no idea how to > format the third column to calculate the days between the other two.  |  Pages: 1 Prev: Excel-HtmlNext: How to Import data from a different .xls file