I have a list with dates in fields F5-F50 and want to automatically
populate G5-G50 with a date 6 months future. I am using
=DATE(YEAR(G1),MONTH(G1)+6,DAY(G1)) but how do I get it to progress
through the colums so that G5 picks up the date from F5 and adds 6

I want to insert 2 horizantal lines within one cell. How would I do that? Is
that possible with Excel?

i'm trying to create a formula using 88 and .03%. for example, in cell D is
the number "88".  in the next cell, i need the sum of 88 plus 0.03%.  how
would this formula be done?  i've tried =SUM(D22+.03), but that gives me an
error message.  the result in the next cell should be ...

How do I replace the contents of a col of cells & div each by 60 ?
Thank You.

What is an easy way to count the number of days between two dates? Thanks

How can I do a sumif function with multiple criteria?
For Example
I have 2 columns that i want to sort by criteria and 1 different column that
i want to sum.

I have 3 sheets and on sheet 1 I have two sections for comments. Each comment
section has 13 rows that have columns A-I merged. On sheet 2 I also have two
comment sections using the same column setup but with 23 rows. At the end of
the 13th row on sheet 1 for each section, I want ...

first of all i would like to say thanks to all of you out there who are
actualy trying to help me with this.
in excel 2003 we have option to split spreedsheet into four my going
Window>Split but my question is if i want to split that into 6 or more, how

How can I get by formula, in a column, the list of unique elements in a
matrix of x columns x rows.
For example:
A1: A5 ={1,2,3,4,5}

I am having difficulty entering data in a cell as Longitude or Latititude. Is
there a way to format a cell for these? If not, how do I indicate the
minutes? I found the degree symbol but I don't know how to enter it without
going to 'insert symbol' each time I want to use it. I ...

I have a list with dates in F5-F50. I would like to automatically
calculate the date six months future to populate automatically in
G5-50. I have found this by searching:
=DATE(YEAR(F1),MONTH(F1)+6,DAY(F1))   but how do I get the function to

Please help this beginner!  I export a Foxpro database to an Excel
spreadsheet.  In a separate (job quote) spreadsheet I try to match a quote
number to it's corresonding row in the exported spreadsheet and fill in cells
in the quote sheet.  What I get is #N/A.  If I format the ...

ie. click the cell, have a calendar pop up and select the desired date and
the date is in hte cell

hi,
i have a pivot table which includes a column based on the [cat] column.  
well i ant it to show a count for this column.  well the only problem is that
in this column there apears either the word "cat" or " ". so its not actually

Good Morning, I am using Excel 2003 with Windows XP.  
In cell A I have a list of 40 values and I am trying to pull a random
sample.  In column B I put Rand() and in Column C I put
=INDEX(A$1:A$200,RANK(B1,B$1:B$200))