| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formula w/Date=Where did I go wrong?
This seemed simple. I need to determine if a date is in the fiscal year, and
if so, show data in a seperate column. (i.e. if a date in column a is between x and y, show the amount in column b in column c, or if no, show nothing) I thought this would work, but no go. =IF(AND(C16=7/1/2007,C16<=6/31/2008),E16,"") Where did I go wrong? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formula w/Date=Where did I go wrong?
=IF(AND(C16=--"7/1/2007",C16<=--"6/31/2008"),E16,"")
"Cbreze" wrote: This seemed simple. I need to determine if a date is in the fiscal year, and if so, show data in a seperate column. (i.e. if a date in column a is between x and y, show the amount in column b in column c, or if no, show nothing) I thought this would work, but no go. =IF(AND(C16=7/1/2007,C16<=6/31/2008),E16,"") Where did I go wrong? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formula w/Date=Where did I go wrong?
Thanks for the fast response Mama, but that returned a #VALUE!
My cell values are as follows: c16 is 1/27/2008, E16 is 2,025.00; there are no formulas in those cells. "Teethless mama" wrote: =IF(AND(C16=--"7/1/2007",C16<=--"6/31/2008"),E16,"") "Cbreze" wrote: This seemed simple. I need to determine if a date is in the fiscal year, and if so, show data in a seperate column. (i.e. if a date in column a is between x and y, show the amount in column b in column c, or if no, show nothing) I thought this would work, but no go. =IF(AND(C16=7/1/2007,C16<=6/31/2008),E16,"") Where did I go wrong? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formula w/Date=Where did I go wrong?
Always best to stick to non-ambiguous dates
=IF(AND(C16=--"2007-07-01",C16<=--"2008-06-31"),E16,"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Cbreze" wrote in message ... Thanks for the fast response Mama, but that returned a #VALUE! My cell values are as follows: c16 is 1/27/2008, E16 is 2,025.00; there are no formulas in those cells. "Teethless mama" wrote: =IF(AND(C16=--"7/1/2007",C16<=--"6/31/2008"),E16,"") "Cbreze" wrote: This seemed simple. I need to determine if a date is in the fiscal year, and if so, show data in a seperate column. (i.e. if a date in column a is between x and y, show the amount in column b in column c, or if no, show nothing) I thought this would work, but no go. =IF(AND(C16=7/1/2007,C16<=6/31/2008),E16,"") Where did I go wrong? Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formula w/Date=Where did I go wrong?
Thanks Bob, but unfortunately, still no go.
"Bob Phillips" wrote: Always best to stick to non-ambiguous dates =IF(AND(C16=--"2007-07-01",C16<=--"2008-06-31"),E16,"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Cbreze" wrote in message ... Thanks for the fast response Mama, but that returned a #VALUE! My cell values are as follows: c16 is 1/27/2008, E16 is 2,025.00; there are no formulas in those cells. "Teethless mama" wrote: =IF(AND(C16=--"7/1/2007",C16<=--"6/31/2008"),E16,"") "Cbreze" wrote: This seemed simple. I need to determine if a date is in the fiscal year, and if so, show data in a seperate column. (i.e. if a date in column a is between x and y, show the amount in column b in column c, or if no, show nothing) I thought this would work, but no go. =IF(AND(C16=7/1/2007,C16<=6/31/2008),E16,"") Where did I go wrong? Thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formula w/Date=Where did I go wrong?
try
=IF(AND(C16=datevalue(2007-07-01),C16<=datevalue(2008-06-31)),E16,"") "Cbreze" wrote: Thanks Bob, but unfortunately, still no go. "Bob Phillips" wrote: Always best to stick to non-ambiguous dates =IF(AND(C16=--"2007-07-01",C16<=--"2008-06-31"),E16,"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Cbreze" wrote in message ... Thanks for the fast response Mama, but that returned a #VALUE! My cell values are as follows: c16 is 1/27/2008, E16 is 2,025.00; there are no formulas in those cells. "Teethless mama" wrote: =IF(AND(C16=--"7/1/2007",C16<=--"6/31/2008"),E16,"") "Cbreze" wrote: This seemed simple. I need to determine if a date is in the fiscal year, and if so, show data in a seperate column. (i.e. if a date in column a is between x and y, show the amount in column b in column c, or if no, show nothing) I thought this would work, but no go. =IF(AND(C16=7/1/2007,C16<=6/31/2008),E16,"") Where did I go wrong? Thanks |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formula w/Date=Where did I go wrong?
It's because you have a non existent date as your second criteria, Change it
to --"2008-06-30" AFAIK there will never be a 06/31/08 -- Regards, Peo Sjoblom "Cbreze" wrote in message ... Thanks Bob, but unfortunately, still no go. "Bob Phillips" wrote: Always best to stick to non-ambiguous dates =IF(AND(C16=--"2007-07-01",C16<=--"2008-06-31"),E16,"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Cbreze" wrote in message ... Thanks for the fast response Mama, but that returned a #VALUE! My cell values are as follows: c16 is 1/27/2008, E16 is 2,025.00; there are no formulas in those cells. "Teethless mama" wrote: =IF(AND(C16=--"7/1/2007",C16<=--"6/31/2008"),E16,"") "Cbreze" wrote: This seemed simple. I need to determine if a date is in the fiscal year, and if so, show data in a seperate column. (i.e. if a date in column a is between x and y, show the amount in column b in column c, or if no, show nothing) I thought this would work, but no go. =IF(AND(C16=7/1/2007,C16<=6/31/2008),E16,"") Where did I go wrong? Thanks |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formula w/Date=Where did I go wrong?
Check and make sure your date is really a true Excel date:
=ISNUMBER(C16) That should return TRUE. -- Biff Microsoft Excel MVP "Cbreze" wrote in message ... Thanks Bob, but unfortunately, still no go. "Bob Phillips" wrote: Always best to stick to non-ambiguous dates =IF(AND(C16=--"2007-07-01",C16<=--"2008-06-31"),E16,"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Cbreze" wrote in message ... Thanks for the fast response Mama, but that returned a #VALUE! My cell values are as follows: c16 is 1/27/2008, E16 is 2,025.00; there are no formulas in those cells. "Teethless mama" wrote: =IF(AND(C16=--"7/1/2007",C16<=--"6/31/2008"),E16,"") "Cbreze" wrote: This seemed simple. I need to determine if a date is in the fiscal year, and if so, show data in a seperate column. (i.e. if a date in column a is between x and y, show the amount in column b in column c, or if no, show nothing) I thought this would work, but no go. =IF(AND(C16=7/1/2007,C16<=6/31/2008),E16,"") Where did I go wrong? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional date array formula | Excel Discussion (Misc queries) | |||
| conditional date formula | Excel Worksheet Functions | |||
| Conditional formula date | Excel Worksheet Functions | |||
| Conditional formula date | Excel Worksheet Functions | |||
| Formula "=num.de.semana(Date,2or1)" is WRONG for 2005 | Excel Worksheet Functions | |||
Hybrid Mode
