calculate difference between dates then return yes/no if greater/lower than 5

Hello,

I wonder if someone could help with a formula I'm trying to figure out.

I want to calculate the number of days between two dates, and if it's 5 or less, I want to return "yes" in a third cell (greater than 5 should return "no").

For example, difference between A1 and B1 is 4, so C1 returns "yes"

I hope that makes sense. Is there a formula I can use to do this in one cell? I've had a look and I can't find anything that does what I'm after, but of course that doesn't mean it doesn't exist...

Many thanks,

Kerry

Thank you both for the super quick replies and the formula - it works (of course).

A further question if I may...

I've populated a column with the formula, but where the date cells are blank it obviously still returns yes. Is there a way I can add to the formula to make the cell remain blank unless one or both of the date cells are populated?

Many thanks,

Kerry

Amazing, that's perfect , thank you!