Count number of days and formula with text result

Hi to all wizards,


Please help me to automate the attached sheet. Really im poor about excel knowledge.

In column C (DURATION), I want a formula to calculate the days from the date given in column B (ATA) that will result like (8 DAYS)

In culomn E (REMARKS), I want a formula that will result to text like if culomn C (DURATION) is less than 20 days the result is UNDER PROCESS, if column C (DURATION) is more than 20 days the result is FOLLOW UP, if column C (DURATION) is more than 30 days the result is DELAYED and if any date is encoded in column D (RECEIVED DATE) the result is RECEIVED.

I want also to fill the color the ranges from A to E depending on the column E (REMARKS) same as in the attachment.

Im really sorry. I need your help.

Thank you and God bless you always!