Hello Hazy,

Here is a code example using A1 as the cell with the date of Oct, 15 2005. The result of adding 56 days will yield Dec 10, 2005.

Code Example:

With Worksheets("Sheet1")
.Range("A1").Value = .Range("A1").Value + 56
End With

Sincerely,
Leith Ross