| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Auto populate dates from a given start date
I'd like to create a timecard-style spreadsheet where I can enter the date of the start of the pay period (in 6/15/2008 format) and have that auto populate the following dates on a 7-day/week calendar on the corresponding days of the week.
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Auto populate dates from a given start date
=A1+7
Does that work for you? -- Kind regards, Niek Otten Microsoft MVP - Excel <Jim Hammerel wrote in message ... | I'd like to create a timecard-style spreadsheet where I can enter the date of the start of the pay period (in 6/15/2008 format) and have that auto populate the following dates on a 7-day/week calendar on the corresponding days of the week. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Auto populate dates from a given start date
Jim,
Format the cells as you like mm/dd/yyyy (6/15/2008). If the dates are going to be in Cells A2 thru G2, for example. In cell B2 type "=A2 +1". then copy B2 to C2 thru G2. hth :-) "Jim Hammerel" wrote: I'd like to create a timecard-style spreadsheet where I can enter the date of the start of the pay period (in 6/15/2008 format) and have that auto populate the following dates on a 7-day/week calendar on the corresponding days of the week. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DAYS360 where Start Date is Static and End Date is Latter of Two Dates | Excel Discussion (Misc queries) | |||
| Auto-populate other cells based on dates | Excel Discussion (Misc queries) | |||
| auto populate dates | Excel Worksheet Functions | |||
| Auto populate dates | Excel Discussion (Misc queries) | |||
| expanding a start date and end date to show all the dates in a list | Excel Programming | |||
Hybrid Mode
