Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Ok I need to figure out how to show all of the fridays of this year in column
A. And i want the machien to do it. ex. 3/31/2006 4/7/2006 4/14/2006 4/21/2006 .....and so on |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Put the first date in one cell (A1), put the second date in another
consecutive cell (A2). Highlight both cells, move the pointer to the bottom right of the selection and it will turn into a plus sign. Click, hold and drag down until you get to where you want to stop and release the mouse,. -- Hope this helps, MarkN "Tanner" wrote: Ok I need to figure out how to show all of the fridays of this year in column A. And i want the machien to do it. ex. 3/31/2006 4/7/2006 4/14/2006 4/21/2006 ....and so on |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In A1 enter the date of the first Friday you're interested in, i.e. 3/31/06.
In A2, enter this formula: =A1+7 Then copy down as far as needed. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! ---------------------------------------------------------------------------y "Tanner" wrote in message ... Ok I need to figure out how to show all of the fridays of this year in column A. And i want the machien to do it. ex. 3/31/2006 4/7/2006 4/14/2006 4/21/2006 ....and so on |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
Line Chart - show percent and value? | Charts and Charting in Excel | |||
Show values from other sheet | Excel Worksheet Functions | |||
UDF and Calculation tree | Links and Linking in Excel |