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
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=474178