Due date

G

GORDON

I am trying to create a formula that will give me a date due derive
from by adding 12 months to the order date. Then warn me by the orde
date plus 10 months to send out a reminder. I have trie
=date(year(a2),month(a2)+c2,day(a2)) c2 equals 12 for the next months.
then i used =if (a2<=b2, "OK","NOT OK") I get a lot of NOT OKS eve
though column b is less than 12 months. I would appreciate any hel
that you can give me
 
N

Norman Harker

Hi Gordon!

Your two formulas are OK.

Maybe it's just a case of absolutely referencing C2?

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top