Adding Dates to a worksheet

LChevele

New Member
Joined
Oct 5, 2006
Messages
9
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.
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Hi, welcome to the board!

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

LChevele

New Member
Joined
Oct 5, 2006
Messages
9
Nope cause its a date

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

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
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

New Member
Joined
Oct 5, 2006
Messages
9

ADVERTISEMENT

the original format is a date

The orginal formate is a date
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
In this example, I have the date 10/1/06, and in B1: =A1+6

Is this not what you want?
Book1
ABCD
110/1/200610/7/2006
Sheet1
 

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,813
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

New Member
Joined
Oct 5, 2006
Messages
9
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

New Member
Joined
Oct 5, 2006
Messages
9
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...
 

Forum statistics

Threads
1,136,267
Messages
5,674,729
Members
419,523
Latest member
Urnovio

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top