Prev: Excel-Html
Next: How to Import data from a different .xls file
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" <PatBriggs(a)discussions.microsoft.com> 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-Html
Next: How to Import data from a different .xls file