excel

  • Thread starter Thread starter pathenno
  • Start date Start date
P

pathenno

how do i enter weekly dates in cells eg
8/11/09....15/11/09...22/11/09....etc..etc
 
--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
 
If 8/11/09 is in A1, then in A2 use the formula =A1+7, and copy down as far
as required.
 
Put 8/11/09 in A1, 15/11/09 in A2, select both cells and then drag down
with the fill series handle.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dates inbetween 3
Auto filling dates 2
How to use index and match function for determining the value? 1
Complex Look Up (amended) 2
Need to pull <=14 Days, <=30 Days, >30 Days from a date column 3
How to determine the highest occurrence? 4
Finding the week of date 4
macro to add numbers based on set criteria 6

Back
Top