Status of the specific date

[AsDubai]

Hi, i would like to ask everyone's help regarding these details;

1. if the closing date is today = status "Today"
2. if the closing date before 2 days = status "Attention required!"
3. if the closing date before 3 to 7 days= status "Still time"
4. if the closing date past = status "Overdue"
5. if TODAY is THURSDAY and i am going to input the day SUNDAY = status will be TODAY and NOT counted Friday and Saturday

Please what should i do? Thank you.

[Special-K]

=IF(AND(TODAY()>A1,A1<>0),"Overdue",LOOKUP(A1-TODAY(),{0,1,2,3,8},{"Today","Attention required","Attention required","Still time",""}))

You havent said what happens if its beyond 7 days.

I dont understand 5.
Where will you input Sunday?

[AsDubai]

Thank you Special-K i highly appreciated your prompt response.

if beyond 7 days = status will be "Closed"

i attached file for clearer instruction "Sunday".

I hope you that you can still have time to help me.

Sincerely,
Aileen

[JeteMc]

See if the additions to Special-K's formula work for you:

Please Login or Register  to view this content.

Let us know if you have any questions.

[AsDubai]

Thank you very much, its working.

God bless

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.