IF function with 3 logics

that_one_girl

New Member
Joined
Mar 22, 2017
Messages
43
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------------------->
BEGIN Task
Actual Completion
Task Deadline
EE Assigned
Apr-25-17
Apr-26-17
Apr-27-17
Apr-28-17
May-01-17
May-02-17
May-03-17
May-04-17
May-05-17
May-08-17
May-09-17
Apr-25- 17
Apr-25-17
VH
VH
May-01-17
May-09-17
May-03-17
ML
ML
ML
ML
#VALUE!
Jun-19-17
Jun-23-17
VH

<tbody>
</tbody>
 

Delfinus25

Board Regular
Joined
Feb 27, 2016
Messages
80
I'm not QUITE sure I understand your goal, but
=if(AND(Complete<>"",DATE>BEGIN),"DONE",(IF(AND(Dates>=Begin,Dates<=Deadline),$G:$G,"")))
 

Forum statistics

Threads
1,085,542
Messages
5,384,332
Members
401,887
Latest member
Somesh

Some videos you may like

This Week's Hot Topics

Top