Is there a way to use "Netwokdays" to produce a date?
I already use Networkdays in a spreadsheet to calculate the number of
business days between order date and delivery date.  I would like to add a
cell with a formula that would return a date for a given zipcode.

Does SQL.REQUEST work in Excel X under OSX?  Thanks.

I have inherited a spreadsheet where some cells within a column are much
higher than the rows in adjacent columns.  e.g. A7 is equal in height to the
combined height of B7,B8,B9,& B10.
How do I undo this?  I cannot find anything in the help files.

What is the formula to find the PV of a future payment.
I know my payment is going to be $214.29 at 1/1/05.  What is the present
value of this payment on 1/1/04 if the interest rate is 10%.  Does anyone
have a formula for this?

Here is my formula:  =if(iserr(h3/g3),"",h3/g3)
The problem is I am using this data in a line chart and whenever there is a
"", my line drops all the way down to zero.  Can I make the formula
completely blank the cell rather than filling it with a space?  

I'm working with Excel 2003 and trying to look for a way to create some sort
of dynamic references in functions between worksheets in the same workbook.
Let me try to explain -
Say I have a workbook with 12 different worksheets with the names -

I have a list of items in data validation in column A.
Data validation for column B changes depending upon the value selected in
column A.  The dta validation formula I use is...
=IF(A7="Dining Room",DR,IF(A7="Living

Please can anyone help me with this query?
When I came to make a drop down list for data entry in a cell, I used
the method:
Select cell>Menu

Is there anyway you can put a certain time trial into an excel file, so that
you can let people view it... but after say 7 days the file will no longer
open?

and failing miserably :(
I've got two sheets in my spreadsheet.
Sheet1 has a subset of location numbers in ColA
Sheet2 has a lot of columns, one of which is the location number.

I have a file which is stored on our company network.
Accessing the file from my machine gives me the option to open it as
read only. On another employee machine however, it doesn't give this option.
Does anyone know why this is and how to fix please?

I am trying to follow a trend over time of a part.
how can I create a graph that will show date, defect, and the variaous
locations where a defect can occure.
date: day-month

do you know any other system, instead of the one of cpearson, to highlight
column and line of the selected cell?
Like I saw in AS400.
thanks

i am facing a problem with formula,s in excel in Office XP 2002,
the calculated dont seem correct every once in a while . is there any known
bug with it ?
thanks

        A        B
1       3        $1.12
2       8        $0.14
3       15      $1.71