Help needed with nested IF AND Statement

[kyleno]

I am attempting to create an IF AND statement for the following scenario:

Sorry I can't get a screenshot in the Mr. Excel tool is blocked here.

      K                       L                               M                        N                           O                          
02| Start Date	Received Date	        Target Date	  Current Status          Stage Status
03| 4/5/2016	4/15/2016	                 4/12/2016	       1	   
04| 4/5/2016	4/1/2016	                 4/12/2016	       1	   
05| 4/5/2016	4/2/2016	                 4/12/2016	       1	   
06| 4/5/2016	4/6/2016	                 4/12/2016	       1	   
07| 4/5/2016	4/7/2016	                 4/12/2016	       1	   
08| 4/5/2016		                         4/12/2016	       1	  
09| 4/5/2016	4/9/2016	                 4/12/2016	       1	   
10| 4/5/2016	4/10/2016	                 4/12/2016	       1	   
11| 4/5/2016	4/7/2016	                 4/12/2016	       1	   
12| 4/5/2016	4/12/2016	                 4/12/2016	       1	   
13| 4/5/2016	4/13/2016	                 4/12/2016	       1	  
14| 4/5/2016		                         4/12/2016	       1	  
15| 4/5/2016		                         4/12/2016	       1	  	
16| 4/5/2016		                         4/12/2016	       1	   	
17| 4/5/2016		                         4/12/2016	       1	  	
18| 4/5/2016		                         4/12/2016	       1	  	
19| 4/5/2016		                         4/12/2016	       1	  	
20| 4/5/2016		                         4/12/2016	       1	   	          "Follow Up"
21|	               Follow Up	                 4/7/2016	               1	   
22|	               Past Due	                 4/13/2016	       1	  	

Example in cell O20
In cell O20 ("Follow Up"), I originally had tried to use the formula:
=IF(AND(NOT(ISBLANK(L20));(TODAY()>=($M$21),$L$21,""))

It does not want to work.

What I'm looking to do is the following:
IF todays date is greater than or equal the date in cell M21 AND blank THEN insert text from cell L21

Any help? Please and thank you.

 

[Jonmo1]

Lools like a misplaced )

=IF(AND(NOT(ISBLANK(L20));(TODAY()>=($M$21),$L$21,""))

Should be

=IF(AND(NOT(ISBLANK(L20));(TODAY()>=($M$21)),$L$21,"")


Also, your description says you want to return L21 if today >= M21 AND L20 IS Blank
But your formula is doing is NOT blank

You probably need to remove the NOT part.

 

[Jonmo1]

That still leaves a mismatch of too many ( and not enough )

All the extra () around values is confusing things.
And you have a ; that should be a comma (or maybe the other way around)

Try
=IF(AND(NOT(ISBLANK(L20)),TODAY()>=$M$21),$L$21,"")

 

[kyleno]

I used =IF(AND((ISBLANK(L20)),TODAY()>=$M$21),$L$21,"") and it worked! thanks so much!

 

[Jonmo1]

You're welcome.

You can remove the extra () around (ISBLANK(L20))

They're not 'Wrong', but they're not necessary.
And the more ()'s you see in a formula, the harder it is to read and follow.