Date counting with data from Access
 

I am working with Excel 2003. We have set up a querry to pull data from our
Access database. One of the needs we have is to average the number of days
for a task. To do this we have a formula set up to count the days and
average them. It seems simple enough to do. The problem I am finding is
that we have a lot of one day tasks that are being counted as 0. If the
start date is the same as the finish date it equals 0, and if the end day is
one day later it counts 1 instead of 2. Is there a way to format it to
recognize the first day as a day?

Date counting with data from Access
 

Try this:

=finishdate - startdate +1

Hope this helps.

Pete

On Sep 10, 9:10 pm, ValEng wrote:
I am working with Excel 2003. We have set up a querry to pull data from our
Access database. One of the needs we have is to average the number of days
for a task. To do this we have a formula set up to count the days and
average them. It seems simple enough to do. The problem I am finding is
that we have a lot of one day tasks that are being counted as 0. If the
start date is the same as the finish date it equals 0, and if the end day is
one day later it counts 1 instead of 2. Is there a way to format it to
recognize the first day as a day?