My guess is that you have a text entry in either B or C, not a number that can be used to calculate a MONTH or a DAY...hence the #VALUE error that Excel returns when trying to do date calculations on non-valid date values.

Good Luck