View Single Post
  #3  
Old June 22nd, 2009, 01:31 PM posted to microsoft.public.excel.worksheet.functions
Joel
external usenet poster
 
Posts: 2,855
Default is there any built in function to draw lines

You can DRAW lines using the drawing toolbar like in Paint

View - Toolbars - Drawing.

Dates are really numbers so you can use the autofill features in excel to
continue a sequencye of numbers. so if you extended a sequence of numbers
like 1, 3, 5, 7, ... you can use the same method with dates. Each DAY is
equal to 1.

So if you started a sequence

1-Jan-09
1-Feb-09

you would get

1-Jan-09
1-Feb-09
1-Mar-09
1-Apr-09
1-May-09
1-Jun-09
1-Jul-09
1-Aug-09
1-Sep-09
1-Oct-09
1-Nov-09
1-Dec-09
1-Jan-10
1-Feb-10
1-Mar-10


This is really very strange since the number of days in each month is
different!!!!!!!

You should reaqlly get

1/1/2009
2/1/2009
3/4/2009
4/4/2009
5/5/2009
6/5/2009
7/6/2009
8/6/2009
9/6/2009
10/7/2009
11/7/2009
12/8/2009
1/8/2010
2/8/2010
3/11/2010




"krishnan" wrote:

Having given two dates is there any way to plot line from these two dates. (
say dates in continuous cells)

Regards,

Krish