Excel, date-sensitive, 2-part formulas
 

I am trying to figure out a formula for billing in Excel 2003.
I want to be able to enter # of pmnts based on date.
So far I have:
=if(b239217,3,2)
meaning: if date (b2) is greater than 5/14/07, 3 payments, otherwise2.
BUT I also want to say: AND if the dates in B2 are less than 5/1/05, 1 pmnt.
Anyone can help?
Thanks

Excel, date-sensitive, 2-part formulas
 

Hi

Try
=IF(B2<--"01/05/07",1,IF(B2--"14/5/7",3,2))

--
Regards

Roger Govier


"kblostyankee" wrote in message
...
I am trying to figure out a formula for billing in Excel 2003.
I want to be able to enter # of pmnts based on date.
So far I have:
=if(b239217,3,2)
meaning: if date (b2) is greater than 5/14/07, 3 payments, otherwise2.
BUT I also want to say: AND if the dates in B2 are less than 5/1/05, 1
pmnt.
Anyone can help?
Thanks

Excel, date-sensitive, 2-part formulas
 

One way:

=1 + (B2DATE(2007,5,1)) + (B2DATE(2007,5,14))



In article ,
kblostyankee wrote:

I am trying to figure out a formula for billing in Excel 2003.
I want to be able to enter # of pmnts based on date.
So far I have:
=if(b239217,3,2)
meaning: if date (b2) is greater than 5/14/07, 3 payments, otherwise2.
BUT I also want to say: AND if the dates in B2 are less than 5/1/05, 1 pmnt.
Anyone can help?
Thanks

Excel, date-sensitive, 2-part formulas
 

Thank you, yes that was very helpful, I had to mess with the dates a little,
but PERFECT!!
Well, since you're so smart, what if I want to add one more?
if b2 5/30/07, then 4 pmnts?
If you can figure that one out, I've got an even tougher one that I haven't
even begun yet.
Thanks
Kathleen

"Roger Govier" wrote:

Hi

Try
=IF(B2<--"01/05/07",1,IF(B2--"14/5/7",3,2))

--
Regards

Roger Govier


"kblostyankee" wrote in message
...
I am trying to figure out a formula for billing in Excel 2003.
I want to be able to enter # of pmnts based on date.
So far I have:
=if(b239217,3,2)
meaning: if date (b2) is greater than 5/14/07, 3 payments, otherwise2.
BUT I also want to say: AND if the dates in B2 are less than 5/1/05, 1
pmnt.
Anyone can help?
Thanks