Am using the following formula to determine which quarter a payment was made.
The first statement returns true, however, the second returns false and the
date is 1/21/10.
=IF(AND(G1512/31/09,G15<4/1/10),"1Q","Continue")
Thanks!