I need to conditionally format based on the contents of two other
worksheets, so I've created named ranges. Since I have to do a whole bunch
of cells, I figured I'd make two single-cell named ranges and just use an
offset to get the two relative values for each cell I need to ...

I want to count the number of times a specific string occurs in a row.  Then
I want to add whole numbers and decimals.  Ex:
Cells B1, B4, B5, and B10 contain the letter "W".  Each "W" counts as 1 for
a total of 4.  Cell B13 contains the string "S.5".  I want to this item to

I have a spreadsheet with imported employee data from an ODBC file.  The
dates (hire date; birth date) come across as mmddyyyy (i.e. 11151988) instead
of mm/dd/yyyy (11/15/1988).  I tried to custom format the cells (using
mm/dd/yyyy) and I get #######.  Same result if I format as ...

The following formula was provided to me a while ago so that i could make the
following statement happen for a monthly cash flow...take the month i input
into a cell and then find the corresponding month in another row and then
return the sum of the next 12 months of cash flow.  ...

Ok for any given row, I want to turn colums B:M green if columns L:M
are not blank. In other words, when I enter something in any cell in
columns L:M, I want those cells as well as the cells to the left of
them to turn green (except A, but I could be flexible there if I had

How do I display the 15th of the prior month?
A1 = 09-05-07
B1  = display 08-15-07

I think my problem is simple but not sure show to grab it.
I have created a new sheet called IMS-Data which is a linked sheet to a
Microsoft Access Table with data.  In Sheet1 I am looking for the data via
the VLOOKUP.  Because the data table length may change in size I wanted to

I am getting an error message on the 8th time I use IF(AND) in the same
formula. Is there a maximum number of times you can use this combonation in a
singular formula?? If so, how do I end the first part of the formula but
start a second part ??

How do I minus 12 weeks from a starting date?
Thanks for your assistance

Any help with this would be greatly appreciated.
I am running Excel 2003 on a normal desktop as part of Office Professional,
on Windows XP Professional.
I recently installed (successfully it seemed) an Excel add-in:

Hi All, I have a worksheet that has several columns, one with dates.
I would like to sort the rows by that date column. When I click the column
and sort it sorts only that column. I would like all rows to stay associated
with there original rows (more like a database would) Any ...

The following is a hardcoded formula in a worksheet, call it the
CurrentSheet..
='210208345'!FSPTX/'210208345'!CurrentValue
Where '210208345' is the name of  a worksheet,  and FSPTX and CurrentValue

I have been trying to figure this out for quite a while and can't get
anything to work. Here's what I have.
A list of due date, date submitted.  I want to show in another column, when
something is late or on time. If not submitted yet, and due date is today or

I have a spreadsheet with time displayed as 19:46.  This is a text string and
I would like to convert it to 7:46 PM.
Is there a formula that will convert these text strings to time?  
Thanks for the help......

I have been using two functions on my toolbar "Insert stock quote" and
"update quotes". These functions have been on my toolbar for some time and I
use them to update daily stock prices in my excel spreadsheet. I am now using
a second desktop computer and the toolbar does not ...