BlueskiesChicago
New Member
- Joined
- Apr 25, 2002
- Messages
- 2
I need to add or subtract a time period (2 months, for example) to or from a date in another cell. If the other cell is blank, I receive a "1900" date in the new cell when adding; and a "NUM!" remark when subtracting.
If my formula for B17 is
=DATE(YEAR(B39),MONTH(B39)-2,DAY(B39))
and B39 is as yet blank, is there a way to hide the "NUM!" remark until B39 has some information entered?
Thanks for any assistance!
If my formula for B17 is
=DATE(YEAR(B39),MONTH(B39)-2,DAY(B39))
and B39 is as yet blank, is there a way to hide the "NUM!" remark until B39 has some information entered?
Thanks for any assistance!