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.