Thread: Dates in IF statements
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Troubled User
 
Posts: n/a
Default Dates in IF statements
If your date is in cell A1, the formula would be:

=IF(AND(A131990,A1<32355),+U18,0)

If you type a date in Excel and change the format to "," format, it will
give your the date values as above.


"ScottEslick" wrote:


I would like to enter a date in a cell, then if the date falls between a
range say Aug 1,1987 to July 31,1988, then return the value U-18. I have
ranges from U-4 to U-18.

Thanks!!!! Scott


--
ScottEslick
------------------------------------------------------------------------
ScottEslick's Profile: http://www.excelforum.com/member.php...o&userid=30622
View this thread: http://www.excelforum.com/showthread...hreadid=502755


Reply With QuoteReply With Quote