Display the days between start & end date columns

  • Thread starter Thread starter Pat Briggs
  • Start date Start date
P

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.
 
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!
 
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.
 
Back
Top