Hi, I have a excel project to do with dates but I have no idea where to begin! For an upcoming review the message "ALERT" should appear 6 days before the review date, otherwise the word "PENDING" should appear. If the review date has passed "PAST" should appear.

When should show the amount of days left before the review date. If the review day has passed, nothing should appear.

Review date is 90 days after the start date. This is the only one I could figure out. =B5+90 But I can't figure out the formatting.
And for revised review date, move the review date back to the previous Friday if the review date falls on a Saturday or Sunday.

Thanks! Here is what it should look like! http://imgur.com/jq5iqp3