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

Help with Date Formula
 

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

Help with Date Formula
 

=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

Help with Date Formula
 

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

Help with Date Formula
 

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