I have been struggling to create a nested formula for my worksheet based on the following business rules (conditions):

IF Assessment Date falls within 10 days, the status (cell) shows "yellow",
If assessment date falls within 11-25, the status cell shows "Red",
and anything after 25 days, the cells shows "green"

Any help would be much appreciated.
Thanks,
Shoro