PC Review


Reply
Thread Tools Rate Thread

automatically set up dates 2 weeks apart

 
 
William Storey II
Guest
Posts: n/a
 
      17th Nov 2003
i want to be able to make the date in a cell be two weeks difference(14 days
exactly) from the cell above it how would i do this ?


 
Reply With Quote
 
 
 
 
Katherine Coombs
Guest
Posts: n/a
 
      17th Nov 2003
say that cell A1 contains a date 18/11/03 (I'm in Australia so we use
dd/mm/yyyy) and you want cell A2 to be equal to that plus 14 days, ie
2/12/03.

In cell A2 type =A1+14

HTH,
katherine

"William Storey II" <(E-Mail Removed)> wrote in message
news:Pgcub.32129$(E-Mail Removed)...
> i want to be able to make the date in a cell be two weeks difference(14

days
> exactly) from the cell above it how would i do this ?
>
>



 
Reply With Quote
 
Anders S
Guest
Posts: n/a
 
      17th Nov 2003
William,

Two ways,

In A1 enter the first date. Select column A as far down as you need and make sure that A1 is the active cell. Then do Edit>Fill>Series and enter 14 as the step value.

Another way is to enter the first date in A1 and the second date in A2. Then select A1:A2 and fill down on A2 as far as needed.

HTH
Anders Silvén


"William Storey II" <(E-Mail Removed)> skrev i meddelandet news:Pgcub.32129$(E-Mail Removed)...
> i want to be able to make the date in a cell be two weeks difference(14 days
> exactly) from the cell above it how would i do this ?
>
>

 
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
Weeks between two Dates Ayo Microsoft Excel Programming 3 8th May 2009 08:38 PM
Calculating number of weeks between dates (start and end dates) =?Utf-8?B?R2VyYWxkIExlbWF5?= Microsoft Excel Discussion 1 28th Mar 2007 01:13 PM
Weeks and dates c991257 Microsoft Excel Worksheet Functions 1 21st Jul 2006 04:05 PM
Weeks between dates =?Utf-8?B?Qm9iYmlB?= Microsoft Excel Worksheet Functions 3 10th Aug 2005 08:17 PM
Dates Between weeks =?Utf-8?B?Um95?= Microsoft Access Queries 2 16th Oct 2004 08:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:28 PM.