Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use the excel timeline function with dates in graphs | Excel Worksheet Functions | |||
undefined function error when creating xls pivot from mdb qry | Excel Worksheet Functions | |||
Function Won't Calculate -- Sometimes | Excel Discussion (Misc queries) | |||
Finding dates within a date range | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |