if formulas

Y

yb

I need help in setting up the following formula:
(IF) Date recd - date due is> than XXXX then =0
& IF DATE DUE - DATE RECD > XXXX if not = 0
Thank you
 
N

Nick

Try This

=IF(A3-B3>0,"Late","Ontime")

where A3 is the received date cell and B3 is the due date cell. You can
also reference a third cell for the number of acceptable days late (i.e.
$a$1)

Regards,Nick
 
Top