View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Jackson
 
Posts: n/a
Default Help with Date Formula

Hello,

I have a workseet with 3 columns:
Date New Company
Mar-06 CompA
May-06 N CompB
Feb-06 CompC

Is it possible to automatically add a "N" under the "New" column if the
current month(May) is added? I can use the TODAY function but I can't get it
to work with just the current month. Any help is appreciated.

Thanks
Mark