Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 15
Default enter date every 7 days

I am creating a wk book and want my dates to be every 7 days. Want it to
look like this
12/20/2009
12/27/2009
1/3/2010
1/10/2010
and so on.. is this a formula thing? I know how to drag the the first
cell and it will populate by 1 but can this be done by every 7th day?
--
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium

Thank-you
Carl R

  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: enter date every 7 days

Entering Dates Every 7 Days Using a Formula in Excel
  1. Enter the first date in the cell where you want the series to begin. For example, enter 12/20/2009 in cell A1.
  2. In the cell below the first date (cell A2), enter the formula
    Formula:
    =A1+
    and press Enter. This formula adds 7 days to the date in cell A1.
  3. Now, select cell A2 and drag the fill handle (the small square at the bottom right corner of the cell) down to the cells where you want the series to end. Excel will automatically fill in the dates every 7 days.
  4. If you want to customize the date format, select the cells with the dates and right-click. Choose Format Cells and select the desired date format from the Number tab.

That's it! Your dates will now be entered every 7 days using a formula in Excel.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,393
Default enter date every 7 days

Enter the starting date in first cell (let's say it is A1)
In A2 enter =A1+7
Pull A2's fill handle down to copy

Excel stores dates as serial numbers starting with 1/1/1900
As an experiment, enter =TODAY() in a cell and then format this cell
General: Dec 20 2009 is day 40167

best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Carl R" wrote in message
...
I am creating a wk book and want my dates to be every 7 days. Want it to
look like this
12/20/2009
12/27/2009
1/3/2010
1/10/2010
and so on.. is this a formula thing? I know how to drag the the first
cell and it will populate by 1 but can this be done by every 7th day?
--
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium

Thank-you
Carl R

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 15
Default thanks

works like a dream
saved me alot of time


--
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium

Thank-you
Carl R



"Bernard Liengme" wrote:

Enter the starting date in first cell (let's say it is A1)
In A2 enter =A1+7
Pull A2's fill handle down to copy

Excel stores dates as serial numbers starting with 1/1/1900
As an experiment, enter =TODAY() in a cell and then format this cell
General: Dec 20 2009 is day 40167

best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Carl R" wrote in message
...
I am creating a wk book and want my dates to be every 7 days. Want it to
look like this
12/20/2009
12/27/2009
1/3/2010
1/10/2010
and so on.. is this a formula thing? I know how to drag the the first
cell and it will populate by 1 but can this be done by every 7th day?
--
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium

Thank-you
Carl R

.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to pull <=14 Days, <=30 Days, 30 Days from a date column Ken Excel Discussion (Misc queries) 3 October 23rd 09 12:53 AM
how do I enter a reoccuring event like once every 9 days kemomama Excel Worksheet Functions 0 January 15th 08 03:51 AM
Conditional Formatting Dates calculating 10 days and 30 days from a certain date Sioux[_2_] Excel Worksheet Functions 2 October 11th 07 02:04 PM
Report Date - Date Recv = Days Late, but how to rid completed date MS Questionnairess Excel Worksheet Functions 1 January 24th 07 11:05 PM
Auto enter date when data in enter in another cell Brian Excel Worksheet Functions 5 December 7th 06 06:44 PM


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"