PC Review


Reply
Thread Tools Rate Thread

How to Auto populate dates from a given start date

 
 
Jim Hammerel
Guest
Posts: n/a
 
      13th Jun 2008
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 With Quote
 
 
 
 
Niek Otten
Guest
Posts: n/a
 
      13th Jun 2008
=A1+7

Does that work for you?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

<Jim Hammerel> wrote in message news:(E-Mail Removed)...
| 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 With Quote
 
FloMM2
Guest
Posts: n/a
 
      14th Jun 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-populate other cells based on dates Freddy Microsoft Excel Programming 1 27th Oct 2009 09:21 PM
Auto-populate other cells based on dates Freddy Microsoft Excel Programming 2 27th Oct 2009 06:46 PM
Auto Populate dates mustangchic2006 Microsoft Access 1 11th Nov 2008 02:40 PM
auto populate dates dusty Microsoft Excel Worksheet Functions 1 15th Jul 2008 05:14 AM
Auto populate dates waiter11 Microsoft Excel Misc 2 28th May 2006 09:50 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:58 PM.