I am attempting to create a macro that will convert a date formula to a
standard date which will not show the formula. Following is the formula.

1/1/2007 is the first cell
A1+7 gives us 1/8/2007.

I need now to make the cell with A1+7 to yield just the date without the
formula without the formula.

Can anyone help.
--
Tom