I need to create a formula that counts the number of times there is an overdue date in column I, where the corresponding cell in column J is blank.
I enter a date in column H (date appointed). There is a formula to auto-fill column I (date due) which is:
=IF(ISBLANK(H6), " ", EDATE(H6,6))
I need to create a formula to count the number of dates in column I which are older than today but only if the corresponding cell in column J is blank.
I have tried:
but I suspect it is counting the auto-fill formula in column I.