Adding Dates to a worksheet

[LChevele]

Here is one that has me stumped..

I want to have my worksheet start with a date and automatically add 6 days to that orginal date.

Ex: 10/1/06 - want to add in the next cell- 10/7/06
The cell will automatically add the 6 days after the 1st.

I tried using an expression like:
=DateAdd("d", +6, [PromisedDate])

But either I didnt get it correct OR its not what I am looking for.

In essence, the whole worksheet will keep having rolling dates for each week, kinda like a time sheet, except this will just put the dates for that week. EX: 10/1/06-10/07/06

Is there a nice formula for this ? or do I need to create an expression ?

Tired of beating my head each week I have to manually change the dates, which I do forget on a regular basis.

 

[Scott Huish]

Hi, welcome to the board!

Assuming a date in A1, how about
=A1+6

 

[LChevele]

Nope cause its a date

Nope that wont work cause it formatted as a date.. tried that too...

 

[nbrcrunch]

You do not want it to format as a date? What should it format as?

No matter, just go into menu option: Format > Cells and format as you want.

 

[LChevele]

the original format is a date

The orginal formate is a date

 

[Scott Huish]

In this example, I have the date 10/1/06, and in B1: =A1+6

Is this not what you want?

Book1
	A	B	C	D
1	10/1/2006	10/7/2006
Sheet1

 

[sykes]

LChevele
Welcome to the board!!

I can assure you that Hot Pepper's advice is very good.
If you take a brand new worksheet, put a date in A1 (whether it's formatted as date or not) then in B1 put the formula (in the formula bar) =A1+6 and click return, then a date 6 days later will be displayed in B1.
Furthermore, if you use the fill handle in B1 and drag it across the sheet, each subsequent cell will display the date another 6 days on , and another, and another........

Try it - it works!

If it's not working in your workbook then there's another reason for this.

==============================================

EDIT - Sorry HP - tripped over you there!

 

[LChevele]

Okay who can I sent this to for help? or post it for others

Okay who can I sent this to for help? or post it for others ?

 

[LChevele]

I dont think I am stating myself very clearly.. But his answer worked when I opened up a blank worksheet and copied it over the the other one..
maybe I had some left over formatting in there or something...

 

[LChevele]

Thanks.. I appreciate it..