if statement, need 3 results [closed]

问题:

Asked this question earlier, hopefully I can craft it better. I have 5 columns each, that could have dates entered. If the date is less than 14 days, the status column shows "current" if false it shows "overdue". But I need to add: if any date is entered into the 5th column the status column will show "complete"

回答1:

Right now this is what I'm envisioning...

but what you're after and your current setup is very unclear...