HELP!!!!!!!!
If your date difference is calculated in a separate cell, then test if no end
date and cell to blank.
You can then AVERAGE the date diff column
Column A = Start date
Column B = End date
Column C = Date difference:
=IF(B2="","",B2-A2)
AVERAGE column C
HTH
"bumblebug787" wrote:
Well, the problem is that I do have the start date listed - but the end date
is blank. I am wanting an average of mowing cycles - I have a start date for
each cycle, but not an end date yet. Is there a way to find the average for
just those with an end date?
"Toppers" wrote:
The AVERAGE function excludes BLANK cells - what is your formula?
"bumblebug787" wrote:
How do I exclude empty cells when trying to average columns? I am doing a
large sheet of date differences and want to exclude any empty cells from the
calculations.
|