Volatile Symbol

[DOUG]

In the date formula below, in VBA, what does "()" mean"? The formula checker
says it is "volatile". I believe I may have mis-applied the formula, since
it is not counting the number of days between dates correctly. Please advise.

=IF(F11-TODAY()<365,"YES","NO")

DOUG

 

[DOUG]

Benji: Thank you. Actually, the formula I hit upon was as follows...

=IF(TODAY()-N2>=365,"YES","NO")

It did not work the other way, because it yielded a negative number. So,
reversing the order was the correct solution. But, the first time I tried
it, it did not work as my syntax was a little bit off. MS Excel lept in to
help me in this case, and all is well with the world.

Sincerely,
DOUG