Hello everyone. I need help with the following:
I have two columns:
Column A is for entry of any date in cell C6
Column B contains a formula (i.e., =C6+10) to calculate a due date 10 days from the date in Column A
The problem is, anytime I erase the date in Column A, or leave it blank, a default date appears in Column B (i.e., 1/10/00).
Is there a way to leave Column A blank and at the same time have Column B blank as well?
Bookmarks