Thread: If Statement - Returning Quarter based on Specific Date
View Single Post
  #1  
Old March 29th, 2010, 03:26 PM posted to microsoft.public.excel.newusers
Jamie
external usenet poster
  
Posts: 317
Default If Statement - Returning Quarter based on Specific Date
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,G154/1/10),"1Q","Continue")
Thanks!