I need a formula that tells me 4 options based on a date in C3:

Overdue= the date has passed

Approaching= date is 5 days away

Pending= normal status

Complete: if A1 is = Yes then Complete

What I currently have is this :

=If(TODAY()-C3<=5, "Aproaching","Pending")

I'd be really grateful for any help thanks!