#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tanner
 
Posts: n/a
Default show fridays

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MarkN
 
Posts: n/a
Default show fridays

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ragdyer
 
Posts: n/a
Default show fridays

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
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
How do I show break in bar graph to show large and small numbers GK Charts and Charting in Excel 1 December 19th 05 08:23 PM
Line Chart - show percent and value? PK Charts and Charting in Excel 5 November 18th 05 04:24 PM
Show values from other sheet TONY Excel Worksheet Functions 0 August 31st 05 03:03 PM
UDF and Calculation tree Ken Wright Links and Linking in Excel 1 February 6th 05 04:58 PM


All times are GMT +1. The time now is 03:39 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"