I have a project estimation worksheet where I am calculating the number of
months remaining, then adding the current date + Months using
=DATE(YEAR(C11),MONTH(C11)+H11,DAY(C11)) where C11 is the current date and
H11 is the number of months expressed at a number. It works fine when the
month field is 1. When the month field is <1 it totally ignores it and the
result ends up being = the start date. Is this "By Design" or a bug?