View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ranjit kurian Ranjit kurian is offline
external usenet poster
 
Posts: 83
Default If function for Current month

I have a column called as Month, and this column contains only Month details
in mmm/yy formate, i need to use the IIF function for some reason, if the
month is current month(Jan/09) and previous month(Dec/08) the result should
be YES,
If its prior to current and previous months(oct/08, nov/08) the result
should be NO