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
|