Formula Help

[Jennifer]

Hi.... Can someone please help me with a formula that calculates the following:

Cell V249 holds a date (10/21/1994).... If this cell is equal to or greater
than 10/21/1994 and today's date is 30 days greater then =2

Thanks!
-Jennifer

 

[firefytr]

Hi Jennifer,

Maybe something like the following ...

=IF(AND(V249>=10/21/1994,V249+30<TODAY()),2,"False")

Is that what you're looking for? HT

 

[Frank Kabel]

Hi
try
=IF(AND(V249>=DATE(1994,10,21),TODAY()>V249+30),2,"not defined")