Finding averages

First I am curious as to why are you using

=DATEDIF(C6,C10,"d")

instead of simply

=C10-C6

But as to your question do you have both the dates and the formulas to find the differences in the same column?

Cutter,

I used a formula I found on the net. I will try using your suggestion, seems a lot simpler.

As to your question, yes, I have the dates and the formula in the same column.

Regards,

GT

Can you put the formulas to calculate differences in a separate column to simplify things?

Or are you stuck with the way you have it?

I think with some rework, I may be able to have the formulas in a separate column and not part of the "spreadsheet".

What if that does not work?

You'd better post a sample file with any private data removed.

Sorry Cutter, how do I attach the file?

When you make a post you will find a "Manage Attachments" button in the second section of the "Additional Options" area which is directly below the "Submit Reply" button.

Click on that "Manage Attachments" button and a new window opens.

Click on one of the "Choose File" buttons and browse to your sample file and double click it.

Click the "Upload" button and when you see your file's name appear you can close that window.

Then hit the "Submit Reply" button.

Attached is the file

You are getting the #NUM error in Cell C4 because you have a #NUM error in Cell C31 which is part of Cell C4's formula.

Place this formula in Cell C11:

=IF(C10="","",C10-C6)

then copy it to the other appropriate cells in Col C

The result in C4 will give you a result of 52.8

Thanks so much Cutter!!!

You're quite welcome.

Don't forget to mark your post as SOLVED

Yep, what ChemistB says. Click on the drop down at the extreme right end of the formula bar.

How did you manage to do that???

Brain fart....

Thanks Cutter & ChemistB!

Brain Fart.....

Thank you both!

Me thinks you also have wrong date in Cell D6!

Already corrected....