View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wiggledg wiggledg is offline
external usenet poster
 
Posts: 2
Default In XLS, how do IF stmt for IF a date is after another date...?

In Excel, how can I create an IF statement to return a value or text IF a
DATE is after or before another date? It doesn't seem to recognize dates and
is returning all the same value in the current IF statement I've created.
I'm not sure if it has something to do with formatting but I've changed the
formats to Dates, General, Text, etc and the IF statement still doesn't
work........