Adding Formulas and corrections in Excel Spreadsheet

I have an excel spreadsheet that I need formulas added to or corrected. The “DATE RECEIVED” and “DUE DATE”- (30days out) columns are already done however I’m not sure if i did it correctly. I need the “DAYS LEFT” column to have a countdown to 0 and also turn Red when it reaches 15 days since date received, this way the worker knows they have had the case 15 days and need to work it asap. As of now, it is backwards. If you can add a chart that shows how many cases were Closed/Incomplete, Assigned, Pending Records, and Denied by the month, that would be great, (All under Column “DECISION”. One more thing, I need to open this with Google Sheets as well, currently when I email myself a copy and open this version on my PC for work on Google sheets, the DAYS LEFT column will not show up as red.

Requirements: 300

WRITE MY PAPER