#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default excel

how do i enter weekly dates in cells eg
8/11/09....15/11/09...22/11/09....etc..etc
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default excel

--In the first cell enter the 1st date (say in A1). You can enter the current
date using the hot key Ctrl + ; and then edit to suit
--In cell B1 enter the below formula annd copy/drag across cells...as required
=A1+7

If this post helps click Yes
---------------
Jacob Skaria


"pathenno" wrote:

how do i enter weekly dates in cells eg
8/11/09....15/11/09...22/11/09....etc..etc

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default excel

If 8/11/09 is in A1, then in A2 use the formula =A1+7, and copy down as far
as required.
--
David Biddulph

"pathenno" wrote in message
...
how do i enter weekly dates in cells eg
8/11/09....15/11/09...22/11/09....etc..etc



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default excel

Put 8/11/09 in A1, 15/11/09 in A2, select both cells and then drag down
with the fill series handle.

pathenno wrote:

how do i enter weekly dates in cells eg
8/11/09....15/11/09...22/11/09....etc..etc


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



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

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

About Us

"It's about Microsoft Excel"