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

=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

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

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" <(E-Mail Removed)> wrote in message
news:A2F8994D-2D36-4449-9FA4-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:A2F8994D-2D36-4449-9FA4-(E-Mail Removed)...
> > 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
>
>
>

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" <(E-Mail Removed)> wrote in message
> > news:A2F8994D-2D36-4449-9FA4-(E-Mail Removed)...
> > > 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
> >
> >
> >

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" <(E-Mail Removed)> wrote in message
news:39036B20-53F5-4D96-9937-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:A2F8994D-2D36-4449-9FA4-(E-Mail Removed)...
>> > 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
>>
>>
>>

Check and make sure your date is really a true Excel date:

=ISNUMBER(C16)

That should return TRUE.

--
Biff
Microsoft Excel MVP


"Cbreze" <(E-Mail Removed)> wrote in message
news:39036B20-53F5-4D96-9937-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:A2F8994D-2D36-4449-9FA4-(E-Mail Removed)...
>> > 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
>>
>>
>>

Like I said; it looks simple, but... Still #VALUE! I checked the formatting
on the subject cells. Nothing that shouldn't be there. C16 is formatted as
a date and E16 is just a monetary value.

Thanks for trying BJ.

"bj" wrote:

> 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" <(E-Mail Removed)> wrote in message
> > > news:A2F8994D-2D36-4449-9FA4-(E-Mail Removed)...
> > > > 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
> > >
> > >
> > >

Nice tool, and yes, it returned TRUE.

"T. Valko" wrote:

> Check and make sure your date is really a true Excel date:
>
> =ISNUMBER(C16)
>
> That should return TRUE.
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Cbreze" <(E-Mail Removed)> wrote in message
> news:39036B20-53F5-4D96-9937-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:A2F8994D-2D36-4449-9FA4-(E-Mail Removed)...
> >> > 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
> >>
> >>
> >>
>
>
>