IF function with 3 logics

[that_one_girl]

Hi - so I have this sheet for work. I need it to do a few things and I can't seem to do it

I have the formula to populate my weekly dates using my EE Assigned initials based on the Begin Task and Task Deadline date ranges

What I can't seem to do, is to get a nested formula, or conditional formatting, that will ALSO notate a change if there is an Actual Completion date listed within my weekly dates

I am ok with either getting the word "DONE" to populate if there is an Actual Completion date, or get the cell in the corresponding row to change color under the Weekly Dates field that correlates to the date entered in the completion field via conditional formatting........

Can anyone help???? I keep getting errors when I try to add this last step.....

I have my data labels below in ( )

Here is the formula I have in the cells under my Weekly Dates headers:
=IF(AND(Dates>=Begin,Dates<=Deadline),$G:$G,"")

(BEGIN) (COMPLETE) (DEADLINE) (G) (DATES)<--------------WEEKLY DATES------------------->[TABLE="class: grid, width: 1141"]
<tbody>[TR]
[TD]BEGIN Task
[/TD]
[TD]Actual Completion
[/TD]
[TD]Task Deadline
[/TD]
[TD]EE Assigned
[/TD]
[TD]Apr-25-17
[/TD]
[TD]Apr-26-17
[/TD]
[TD]Apr-27-17
[/TD]
[TD]Apr-28-17
[/TD]
[TD]May-01-17
[/TD]
[TD]May-02-17
[/TD]
[TD]May-03-17
[/TD]
[TD]May-04-17
[/TD]
[TD]May-05-17
[/TD]
[TD]May-08-17
[/TD]
[TD]May-09-17
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apr-25- 17
[/TD]
[TD][/TD]
[TD]Apr-25-17
[/TD]
[TD]VH
[/TD]
[TD]VH
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]May-01-17
[/TD]
[TD]May-09-17
[/TD]
[TD]May-03-17
[/TD]
[TD]ML
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]ML
[/TD]
[TD]ML
[/TD]
[TD]ML
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]#VALUE!
[/TD]
[/TR]
[TR]
[TD]Jun-19-17
[/TD]
[TD][/TD]
[TD]Jun-23-17
[/TD]
[TD]VH
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Delfinus25]

I'm not QUITE sure I understand your goal, but
=if(AND(Complete<>"",DATE>BEGIN),"DONE",(IF(AND(Dates>=Begin,Dates<=Deadline),$G:$G,"")))