If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




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! 
Ads 
#2




If Statement  Returning Quarter based on Specific Date
=IF(AND(G1512/31/09,G154/1/10),"1Q","Continue")
Your dates aren't being evaluated as dates. They're being evaluated as the math operation: 12 divided by 31 divided by 9 = 0.043010752688172 4 divided by 1 divided by 10 = 0.4 So, if G15 = the date 1/21/2010 then: AND(G1512/31/09,G154/1/10) Will *never* be TRUE. Use cells to hold the dates: A1 = 12/31/2009 B1 = 4/1/2010 =IF(AND(G15A1,G15B1),"1Q","Continue")  Biff Microsoft Excel MVP "Jamie" wrote in message ... 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! 
#3




If Statement  Returning Quarter based on Specific Date
"Jamie" wrote:
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") In that form, 12/31/09 is interpreted as 12 divided by 31 divided by 9, not a date. You can write: =IF(AND(G15"12/31/09",G15"4/1/10"), "1Q","Continue") But that is consider poor form. It is better to write: =IF(AND(G15date(2009,12,31),G15date(2010,4,1)), "1Q","Continue") 
#4




If Statement  Returning Quarter based on Specific Date
This works perfectly now and explained the reason for some of the results.
Thanks!! "T. Valko" wrote: =IF(AND(G1512/31/09,G154/1/10),"1Q","Continue") Your dates aren't being evaluated as dates. They're being evaluated as the math operation: 12 divided by 31 divided by 9 = 0.043010752688172 4 divided by 1 divided by 10 = 0.4 So, if G15 = the date 1/21/2010 then: AND(G1512/31/09,G154/1/10) Will *never* be TRUE. Use cells to hold the dates: A1 = 12/31/2009 B1 = 4/1/2010 =IF(AND(G15A1,G15B1),"1Q","Continue")  Biff Microsoft Excel MVP "Jamie" wrote in message ... 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! . 
#5




If Statement  Returning Quarter based on Specific Date
You're welcome. Thanks for the feedback!
 Biff Microsoft Excel MVP "Jamie" wrote in message ... This works perfectly now and explained the reason for some of the results. Thanks!! "T. Valko" wrote: =IF(AND(G1512/31/09,G154/1/10),"1Q","Continue") Your dates aren't being evaluated as dates. They're being evaluated as the math operation: 12 divided by 31 divided by 9 = 0.043010752688172 4 divided by 1 divided by 10 = 0.4 So, if G15 = the date 1/21/2010 then: AND(G1512/31/09,G154/1/10) Will *never* be TRUE. Use cells to hold the dates: A1 = 12/31/2009 B1 = 4/1/2010 =IF(AND(G15A1,G15B1),"1Q","Continue")  Biff Microsoft Excel MVP "Jamie" wrote in message ... 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! . 
Thread Tools  
Display Modes  

