Display the days between start & end date columns

[Pat Briggs]

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.

 

[Mike H]

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.

 

[Ms-Exl-Learner]

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!

 

[T. Valko]

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.