I need to count the number of cells within a column that contain a date that
is less than/equal to today's date.  What formula can I use to do this?

Hello fellas:
I have a very serius problem, with my General Manager Laptop (vaio), it's a very clean instalation of Windows XP, when I installed Office everything ok, but when she open Excel it sends this message, "Compile error in hidden module: AutoExec", and when she close it, ...

I am looking for a way to dock a button to a particular cell.  I am
also wondering if anyone knows how to Like a cell to a button. Anyideas
would help.

Hi,  I am trying to do a formula that will either return a percentage or
if either of two cells are blank, then I want it to return either a "0"
or "n/a".  Here is my formula   =(J5/H5)-100% (this gives me the
recipacal of the percentage).  It works fine.  Now what do I add to get

I'm sure this is very simple, but can someone please tell me the syntax to
access a cell from another worksheet?
   e.g. =sum(F4+sheet[1]_A1)
Also, is it possible to access a cell from another /file/ ? Id imagine not

Is it possible to link multiple excel workbooks?
Example: I have one workbook named Book1.xls that has 40 sheets in it
and anotehr workbook named Book2.xls I want to link sheets in that book
to sheets in the book1.

I need to count the number of cells in a column that contain a date that is
<= today's date. I've tried using a COUNTIF formula but it's not working.  
HELP!

Ok, so here was my original problem:
I am attempting to nest the and or functions.
I would like the argument to state:
IF C47 and D47 are negative... take the absolute value of g47/d47

Normally to insert a column I would select the entire column, and then
using the popup menu select insert....This would insert another column
adjacent to the highlighted column...
For some unknown reason the insert command on my popup menu is now

I have a worksheet.  
Column 1 is the Expense, Column 2 is the Expense Description.
Column 1 I have it set for Validation List.  
A hidden worksheets is a data link to a SQL server table that contains the

I have a table in columns A trough E and the data in columns  C and D,
I need to repeat and copy in a sigle column(column p for instance) in
this order:
d1

I would like to assign a particular path with the TAB key, i.e. A1 to G3
to B15, etc.  Is there a way to do this?

I am comparing 2 workbooks in Excel. I have names in the 2 columns I am
trying to compare. The problem is the names can be slightly different
e.g. 1 Mysteria Lane could appear as 1 Mysteria Ln. in the other.
Therefore I cannot use exact matching.

I would like to setup a football (soccer league using excel) so woul
like to find out if its possible.
Basically heres how I would like it to work:
1) First of all I would like excel to help me work out fixtures for

   Originally, when I press the direction keys (up, down, left and right)
on the keyboard, the focus is moved from one cell to the cell next to it (in
the corresponding direction). However, the keys become controlling the
scroll bars of the worksheets instead now. How can I ...