Thank you so much Pete! My headache has now disappeared!!!

"Pete_UK" wrote:

If you put your date in A1, enter this formula in B1:

=IF(A1="","",A1+42)

Format this cell as a date in the way you wish and copy down the column
- if you haven't entered a date in column A then the column B will be
blank.

Hope this helps.

Pete