View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Corca Corca is offline
external usenet poster
 
Posts: 11
Default Need a formula to determine if date falls within a date range then

Help.

Cell A1 = 16/1/08
Cell A2 = 1/1/08
Cell A3 = 28/1/08
Formula needed for Cell A4

I would like a formula for:
Cell A4= if A1 =A2 and <=A3 them retuen X

appreciate the help.