Macro or formula for dates?

[Txtaz6763]

I'm wondering if there is any macro or formula that anyone knows of that will automatically input dates.

For example:

In column C I have a certain date.

In column D, I'd like the date 45 days from the date in column C.

Is this even possible?

Thanks in advance!
Lisa

 

[berg891832]

Type your date into cell C1. In D1, enter =C1+45. Format to date if necessary,

Berg

 

[Txtaz6763]

Thanks Berg!

I sure wasn't expecting such a quick reply.

It is most appreciated.

Lisa

 

[apurk45]

Lisa

You may want put this formula in D1
=IF(C1="","",C1+45) assuming your original date will be in cell C1

Apurk45