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"
wrote
in message
news:kermitforney.2asnt5_1152643510.8615@excelforu m-nospam.com...

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