Return info based on Date Range

K

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. :mad:

Heeeeeeeeelp!
 
C

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"
in message
news:[email protected]...
 
S

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
 
C

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
 
Top