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