I'm working on a spreadsheet where I have the month in a cell (dropdown list
from a range called "Months").  Based on what month is in this cell, another
cell has the number of days in that particular month (Range named "Days").  
The year is in another cell.  I need to write a ...

I have a worksheet in which each row is a different job opening with 4
columns = Job, Recruiter, # Days Open, Close Date.  I would like to find the
average # of days open for each recruiter within a Close Date range.   On the
worksheet, a recruiter may have 10 jobs within a Close ...

I'm struggling with changing the date in cell like August 31, 2007
into 31.08.2007, and the range Aug 1, 2007 - Aug 31, 2007 into a
european format date.
I haven't found any good solution yet, so  please give me a hand in

I am working with a data set of 50 values and most formulas say they
calculate through 30 points. Is it just calculating my first 30 points or is
this negated when I enter the entire range- say G1:G50- versus inputting it
in the format provided by the function key

Can any one suggest me the modification for the formula please?
=SUM(IF((exp!$C$3:$C$3000={4,5})*(exp!$D$3:$D$3000="School")*(exp!$G$3:$G$3000="cash"),exp!$L$3:$L$3000))
In place of {4,5} can i give cell address say A1,B1.  Then how the formula
looks like?

Sh1 is a receipt (that I created in Excel) to be filled out by me with the
first receipt being #1.  When filling out, the info is transferred via
formulas to their respected columns in Sh2 where I want to save the info.  I
want to be able to change receipt to #2 but save the info ...

Can the results of a vlookup be sent to a cell other than the one the formula
is in?  Can't protect the cell where the data needs to be as that cell needs
the option to fill in data not found in the vlookup array.

A    B
1  10  20
2  10  0
3  10  -5

I have a list of the months over the next 3 years in column A (format is
01-Jan-08).  Next to that list there is another list of values (starting at
$50,000) next to each date.  In January and July each year (except for Jan
08), I want $500 added to the $50,000, so by the end of ...

Whats the simplest way to create a data validation list from a comma
separated text present in another cell? The text in this cell is
dynamic and keeps changing.
I can think of breaking the text by using MID, FIND, IF into multiple

I run football pool and am trying to find out how to make my life easier lol  
I am looking for the formula I would need where I would put the winning teams
in column A, paste their entry into column B and have column C show a value
of 1 if it matched.  Would appreciate any help  ...

Is there any way of 'exporting' cell comments to show the text in other
cells?
I have a spreadsheet where a large number of cells have comments within
them.  Obviously these are available on screen when the cursor is moved over

I need help.  I am working in a spreadsheet that has a list of ALL of the
providers that I work with.  I need to get information/link information from
another worksheet that has a FEW of the providers on the worksheet.
1. If I link these documents, does Excel automatically ...

From a database some info is generated that reads "20070917 at 1900".
I need to be able to generate "9/17/07 at 19:00"
At first I was thinking I could use a macro to do this, but I have a feeling
there is a much easier formula that can be generated to make the conversion.

Hi, all,
I've combed the discussion group as well as some of the great web resources
for Excel programming & worksheet functions, and I've come to spend way too
much time on what should be a simple data validation formula. First, I just