Help with Date Formula

[Guest]

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

 

[Guest]

Try in B2, and copy down:
=IF(MONTH(A2)=MONTH(TODAY()),"N","")

 

[Guest]

=IF(MONTH(A1)=MONTH(TODAY()),"N","")

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

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

 

[Guest]

It works perfect! Thank you.
Mark