In a work sheet, I have an invoice date (say column A) and a due date (say column H) with the due date being seven days after the invoice date. Because I have become somewhat lazy, I have used the following formula in column H to automatically increment the "invoice date" by seven days to become the "due date":-
=A1+7 (placed in H1 with the subsequent cells following suit, i.e. A2+7, A3+7 etc. placed in the corresponding cell in column H).
The formula works OK but the date 7/01/1900 appears & stays in each cell in column H until such time as I place a date in column A. The correct incremented date then appears.
Does anyone know how to get rid of the annoying 7/01/1900?