B
Brandon
I am creating a formula to calculate Days Late for given Dates. Is there a
function I can plug into a formula so it will ignore Blank Cells, besides the
cell I am referencing in the formula?
For example: =IF(K4="",(TODAY()-J4),(TODAY()-K4))
I am trying to apply this formula to a whole column, and sometimes the dates
are not populated yet, So, if J4 is blank it throws off the formula. Make
Sense? Any help would be greatly appreciated.
function I can plug into a formula so it will ignore Blank Cells, besides the
cell I am referencing in the formula?
For example: =IF(K4="",(TODAY()-J4),(TODAY()-K4))
I am trying to apply this formula to a whole column, and sometimes the dates
are not populated yet, So, if J4 is blank it throws off the formula. Make
Sense? Any help would be greatly appreciated.