Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
Entering Dates Every 7 Days Using a Formula in Excel
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to pull <=14 Days, <=30 Days, 30 Days from a date column | Excel Discussion (Misc queries) | |||
how do I enter a reoccuring event like once every 9 days | Excel Worksheet Functions | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions |