=IF(C2="","",C2+45) entered in E2

Drag/copy down as far as you wish.


Gord Dibben MS Excel MVP

On Wed, 16 Dec 2009 11:31:01 -0800, Nelson
wrote:

Thank you to both of you for the info. The formula works but unless there is
info in column 'C' I get either '# VALUE' or '14-Feb-00' in column E. I am
using Office 2007, if that makes a difference. Is there any way that I can
enter the formula into all of the cells in column E and not get an error
message if there is no info(date) in column C ?