Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Date formula
I need to a formula that says if a cell (B5) equals a certain month between
11/1 and 3/31 then it's a winter month and therefore give me a price from cell (W54). If it's a summer month between 4/1 and 10/31 then it gives me the price from W55. I have this but it's not working: =IF(AND(B5=11/1/2006,B5<=3/31/2007),W54,W55) Thanks for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Date formula
To make Excel treat your dates as dates, enter them as
DATE(2006,11,1) and DATE(2007,3,31) "Daniel Q." wrote: I need to a formula that says if a cell (B5) equals a certain month between 11/1 and 3/31 then it's a winter month and therefore give me a price from cell (W54). If it's a summer month between 4/1 and 10/31 then it gives me the price from W55. I have this but it's not working: =IF(AND(B5=11/1/2006,B5<=3/31/2007),W54,W55) Thanks for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Date formula
Change it to this: =IF(AND(B5=DATE(2006,11,1),B5<=DATE(2007,3,31),W5 4,W55)
-- Brevity is the soul of wit. "Daniel Q." wrote: I need to a formula that says if a cell (B5) equals a certain month between 11/1 and 3/31 then it's a winter month and therefore give me a price from cell (W54). If it's a summer month between 4/1 and 10/31 then it gives me the price from W55. I have this but it's not working: =IF(AND(B5=11/1/2006,B5<=3/31/2007),W54,W55) Thanks for your help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Date formula
Assuming you don't want to update this formula each year, try this:
=IF(OR(MONTH(B5)=11,MONTH(B5)<=3),W54,W55) "Daniel Q." wrote: I need to a formula that says if a cell (B5) equals a certain month between 11/1 and 3/31 then it's a winter month and therefore give me a price from cell (W54). If it's a summer month between 4/1 and 10/31 then it gives me the price from W55. I have this but it's not working: =IF(AND(B5=11/1/2006,B5<=3/31/2007),W54,W55) Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Trending Formula Results by Date | Excel Worksheet Functions | |||
Year-to-date year to date formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |