Working out the date
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
|