Help with Date Formula

M

Mark Jackson

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
 
C

CLR

Another alternative is to use Conditional Formatting on the date column with
the "Formula is" as =MONTH($A1)=MONTH(TODAY()), then apply a background or
font color of choice.......

Vaya con Dios,
Chuck, CABGx3
 
Top