=IF(AND(A2="x",B2-TODAY()<=180),C2,"")


"Dave H" wrote:

Hello,
I'm trying to set up a formula to return cell C2 if A2 is x and B2 is within
180 days of todays date. Ex:
A B C
1 9/1/08 45784

This is what I've tried:

=IF(A2=x & IF(B2-Today()<=180),C2,"")

Any hints would be appreciated.

Dave