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

Try This

=IF(A3-B30,"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

"yb" wrote:

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