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

Try in B2, and copy down:
=IF(MONTH(A2)=MONTH(TODAY()),"N","")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mark Jackson" wrote:
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

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

Vaya con Dios,
Chuck, CABGx3



"Mark Jackson" wrote:

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

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




"Mark Jackson" wrote:

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

It works perfect! Thank you.
Mark

"Mark Jackson" wrote:

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