Thread: Return info based on Date Range
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG SteveG is offline
external usenet poster
  
Posts: 1
Default Return info based on Date Range

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

=IF(AND(A1B1,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(A1DATEVALUE("1/1/2006"),A1<DATEVALUE("1/31/2006")),A1,"")



HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=560409

Reply With QuoteReply With Quote