View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stevec stevec is offline
external usenet poster
 
Posts: 177
Default If date is in the month of Sept, then "1", otherwise "2"

cell a1 = the date

a1 could equal 9/15/2007, 8/20/2007, 9/26/2007, 5/30/2006, etc.

formula please?:

if the date in cell a1 falls in the month of september, then "1", otherwise
"2"

thanks very much!