Hello,

I was wondering if someone can help me figure out why I receive the error
message "#VALUE!" with the formula below. I am evaluating dates. Thank you.

=IF(AND($D:$D<100%,$K:$KTODAY()),"Review
Only",""),IF(AND($D:$D<100%,$K:$K<TODAY()),"Behind
Schedule",""),IF(AND($D:$D=100%,$K:$K<$J:$J),"Comp leted
Late",""),IF(AND($D:$D=100%,$K:$K$J:$J),"Complete d Ahead of Schedule","")