Thanks for responses to my previous question about
calculating difference between two dates.
Can anyone tell me how to display the difference in years
and months rather than days.

I am looking for an article that supports the fact that
office 97 excel macros do not work in office xp excel for
a co-working can anyone point to an article

Working on a spreadsheet which will take information from
a daily variable .xls down load, check the information,
and then return values based on the results of the first
colum of analysis.

I have a very large spreadsheet, however, I want to sort
by Country, last and first.
It will sort by country with no problem, however when I
review the last name column, they are out of order.  For

in a simple list of test of subjects and marks like:
 A  |         B           |      C      |
 #   |   SUBJECT   |  MARK |
-------------------------------

Hi
I am trying to display, or convert a figure to days, hours and minutes
This is for a spreadsheet that keeps record of staff holidays which ca
include odd hours off. Each month's holiday is deducted from the tota

I'm trying to nest an array formula within a complext non-
array formula.. specifically..
=hyperlink(<arg1>,if(<cond1>,"X",<array formula>))
Since array formula require cntl+shift+enter, it ends up

I have =Rounddown('pesticide'!E1/Lookup($E24,
{"a",1;"b",2;"c",3;"d",4}),0)
The rounddown # is zero for all but I want 1 for a, 0 for
b, 0 for c, and 1 for d.  I cannot seem to get anything I

I need to have a column which is user input with two choices:Yes or No.
In each cell down that column, to the end of the sheet. The "yes"
requires do nothing while the "No" requires that cell and all cells to
the right of it in the same row to be colour filled to the end of the

I'm trying to get excel to calculate the difference
between a current date and a pervious date. I want the
current date to update automatically. Can this be done? If
so how?  Thanks in advance

I have the following problem:
The user produce a report that is placed in an empty
Excelsheet (an application). Then the user sometime later
wants to update the report. For this I need to store some

In Excel,  there are 20 worksheets with independent header
and footers defined.
Now I need to change only header en-mass and without
changing the footer.  When I try to change the header by

I have a list of items with item numbers. The Item numbers are:
RB4116
RG4116
TB2116

Can someone tell me how to write a formula for conditional fomatting that will change the formatting of the cell when a date IS entered into the cell and left alone when there is no cell entry
And, while I am at it..is there a way to hide this same contents of the cell (assuming a ...

How do you check text color in a formula?
eg =IF(C4.Color = 'Green', 'GO!', 'STOP!')