Return info based on Date Range

[kermitforney]

I need to have a date returned based on a date range.

Basically IF Cell A1 is between 1/1/06 and 1/31/06 then place the date of A1 into cell B6.

But I don't understand how to input a date range into Excel.

Heeeeeeeeelp!

[SteveG]

Type the date 1/1/2006 and 1/31/2006 in 2 cells say B1 and B2

=IF(AND(A1>B1,A1<B2),A1,"")

This returns a blank if the date in A1 does not meet the criteria. If you don't want to use cell references you could use:

=IF(AND(A1>DATEVALUE("1/1/2006"),A1<DATEVALUE("1/31/2006")),A1,"")



HTH

Steve

[Chip Pearson]

Try the following formula in B6

=IF(AND(A1>=DATE(2006,1,1),A1<=DATE(2006,31,1)),A1,"no")

Be sure to format B6 for a date.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"kermitforney"
<[email protected]> wrote
in message
news:[email protected]...
>
> I need to have a date returned based on a date range.
>
> Basically IF Cell A1 is between 1/1/06 and 1/31/06 then place
> the date
> of A1 into cell B6.
>
> But I don't understand how to input a date range into Excel.
>
>
> Heeeeeeeeelp!
>
>
> --
> kermitforney
> ------------------------------------------------------------------------
> kermitforney's Profile:
> http://www.excelforum.com/member.php...o&userid=32536
> View this thread:
> http://www.excelforum.com/showthread...hreadid=560409
>

[Chip Pearson]

> =IF(AND(A1>=DATE(2006,1,1),A1<=DATE(2006,31,1)),A1,"no")

should be

=IF(AND(A1>=DATE(2006,1,1),A1<=DATE(2006,1,31)),A1,"no")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chip Pearson" <[email protected]> wrote in message
news:[email protected]...
> Try the following formula in B6
>
> =IF(AND(A1>=DATE(2006,1,1),A1<=DATE(2006,31,1)),A1,"no")
>
> Be sure to format B6 for a date.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
>
> "kermitforney"
> <[email protected]>
> wrote in message
> news:[email protected]...
>>
>> I need to have a date returned based on a date range.
>>
>> Basically IF Cell A1 is between 1/1/06 and 1/31/06 then place
>> the date
>> of A1 into cell B6.
>>
>> But I don't understand how to input a date range into Excel.
>>
>>
>> Heeeeeeeeelp!
>>
>>
>> --
>> kermitforney
>> ------------------------------------------------------------------------
>> kermitforney's Profile:
>> http://www.excelforum.com/member.php...o&userid=32536
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=560409
>>
>
>