If Statement for Project Management

[wpavone]

I'm working on a project management worksheet that tracks the progress of actions through several phases. Each phase has a column for the Start Date (column A) and a column for the Finish Date (column B). I want to write a statement that will return nothing if there is no start date entered in column A. If there is a start date entered in column A, I want to compare it with today's date and return G if the start date is more than 7 days from today's date, Y if the start date is 7 days greater than or equal to today's date, and R if the start date is less than today's date. I also want to return a value of B if any date has been entered into column B. The statement is in a column used to display the progress of each action. $K$1 is an absolute reference to today's date. So far I have the following: =IF(ISBLANK(A1),"",IF(A1<>"",LOOKUP($K$1-A1,{-10000,"G";-7,"Y";1,"R"}),IF(B1>=A1,"B"))). G, Y, and R are returning, but the statement is not returning B when a date is entered into column B. How do I correct this?

 

[wpavone]

Yes, absolutely. Thanks so much for all your help! Have a great weekend.

 

[Aladin Akyurek]

Yes, absolutely. Thanks so much for all your help! Have a great weekend.

Glad to hear that. Thanks for providing feedback.