A
AndreaS13
I have a training spreadsheet that uses the date function "Today" along with
the date training was completed to calculate when training is overdue. Is
there a way to have Excel ignore blank cells. Right now it is counting a
blank cell as "Overdue".
My formula is =IF(($C$3-J8)>1095, "OVERDUE", " "), where C3 = TODAY(); J8 is
the date of the last training class and 1095 is the amount of days it would
be considered "overdue".
Thanks,
Andrea
the date training was completed to calculate when training is overdue. Is
there a way to have Excel ignore blank cells. Right now it is counting a
blank cell as "Overdue".
My formula is =IF(($C$3-J8)>1095, "OVERDUE", " "), where C3 = TODAY(); J8 is
the date of the last training class and 1095 is the amount of days it would
be considered "overdue".
Thanks,
Andrea