IF function using dates ?

[barnsey11]

Hi there,

I am trying to create a formula used for commision purposes based on
dates. Ex: if we offer a promotion for september 9/1/05- 9/30/05 fo 5
I would like for the a dicount to apply in the cell but it its afte
that date then give a 0 discount.

I thought this would work but if does not for when the date is in OCT.

IF(Cell)<="9/30/05",5,0

If works if the date you specified is before 9/30 but not after..
Any help would be greatly appreciated.
Thank

 

[Dave Peterson]

=if(a1<=date(2005,9,30),5,0)

Or maybe...

=if(text(a1,"yyyymm")="200509",5,0)

 

[barnsey11]

thank you very muc