View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.