Please help wtih date function!

[skrap222]

Hi,

I am not that great of programming Excel and I have a question that I hope someone can answer. I am hoping to create a function where I can enter a date and have the date 6 days and 14 days into the future pop up automatically after entering the initial date. Does anyone know the proper way to program this? I would appreciate all help.

For example,
If I enter 3/1/05 in column, then I would like 3/7/05 to automatically appear in another column and also 3/15/05 in yet another column.

Thanks in advance!!!
Adam

[AlfD]

Hi!

Put your date in A1
In B1 put =A1 + 6
In C1 put =A1 + 14

This works because Excel stores dates as days counting from its base date of 1/1/1900 (usually) and times as fractions of a day. (See Help: About dates and date systems)

Alf