IF function using dates ?
 

Hi there,

I am trying to create a formula used for commision purposes based on 2
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 after
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.
Thanks


--
barnsey11
------------------------------------------------------------------------
barnsey11's Profile: http://www.excelforum.com/member.php...o&userid=30494
View this thread: http://www.excelforum.com/showthread...hreadid=501469

IF function using dates ?
 

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

Or maybe...

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



barnsey11 wrote:

Hi there,

I am trying to create a formula used for commision purposes based on 2
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 after
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.
Thanks

--
barnsey11
------------------------------------------------------------------------
barnsey11's Profile: http://www.excelforum.com/member.php...o&userid=30494
View this thread: http://www.excelforum.com/showthread...hreadid=501469

--

Dave Peterson

IF function using dates ?
 

thank you very much


--
barnsey11
------------------------------------------------------------------------
barnsey11's Profile: http://www.excelforum.com/member.php...o&userid=30494
View this thread: http://www.excelforum.com/showthread...hreadid=501469