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?

Try this:

=finishdate - startdate +1

Hope this helps.

Pete

On Sep 10, 9:10 pm, ValEng <Val...@discussions.microsoft.com> 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?