If formula for multiple conditions needed pls

Pls look at my attached sheet , i need slight modification in my formula to work better , its not counting/showing the cells if the days left are more than 2 .

What is required result if less than 2 days left?

=IF(C5="","",IF(C5-TODAY()>2,C5-TODAY()&" days left "," no days left ??????"))

Your formula is not working :

My answer should come like : 1 day left .. 2 days left
1. If from today there are 2 days left then 2 days left
2. If from today there is 1 day left then 1 day left

See attached.

=IF(C2="","",IF(C2-TODAY()>=1,C2-TODAY()&" days left "," no days left ??????"))

your formula is okay sir the only thing i want is days for plural and day for singular

Well you need to add a test to see if result is 1, then text is "day".

=IF(C2="","",IF(C2-TODAY()=1,C2-TODAY()&" day left ",IF(C2-TODAY()>1,C2-TODAY()&" days left "," no days left ??????")))