Formula Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top