Hello,

I have this formula: "=IF(MONTH(A7)=MONTH(TODAY(),"N","") which puts the
letter "N" in column B when there is a new contract. This works fine when I
run my report in the current month. Is there a way to get the same result
when I run my report at the beginning of the next month? Any help is
appreciated.

Thanks.
Mark

Mark Jackson wrote:
Hello,

I have this formula: "=IF(MONTH(A7)=MONTH(TODAY(),"N","") which puts
the letter "N" in column B when there is a new contract. This works
fine when I run my report in the current month. Is there a way to
get the same result when I run my report at the beginning of the next
month? Any help is appreciated.

Thanks.
Mark


Hi Mark,

try this:

"=IF(MONTH(A7)=(MONTH(TODAY())-1),"N","")

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy