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