Assuming the field where they tell when they are looking to publish is called Publish Date , the syntax would be: IF(DATEDIFF(Publish Date, $$TODAY)<=2,'this is an Urgent request; please contact ----- at extension ----', IF(DATEDIFF(Publish Date, $$TODAY)<=10,'this is an Expedited request - please c...