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,G15<4/1/10),"1Q","Continue")
Thanks!

If Statement - Returning Quarter based on Specific Date
 

=IF(AND(G1512/31/09,G15<4/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,G15<4/1/10)

Will *never* be TRUE.

Use cells to hold the dates:

A1 = 12/31/2009
B1 = 4/1/2010

=IF(AND(G15A1,G15<B1),"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,G15<4/1/10),"1Q","Continue")
Thanks!

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,G15<4/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),G15<date(2010,4,1)),
"1Q","Continue")

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,G15<4/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,G15<4/1/10)

Will *never* be TRUE.

Use cells to hold the dates:

A1 = 12/31/2009
B1 = 4/1/2010

=IF(AND(G15A1,G15<B1),"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,G15<4/1/10),"1Q","Continue")
Thanks!


.

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,G15<4/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,G15<4/1/10)

Will *never* be TRUE.

Use cells to hold the dates:

A1 = 12/31/2009
B1 = 4/1/2010

=IF(AND(G15A1,G15<B1),"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,G15<4/1/10),"1Q","Continue")
Thanks!


.