Display the days between start & end date columns
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
...
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.
|