I am  looking for a date function that will return the Monday for the week in
which the given date is in. For example cell A1 has the date 2-13-2008 (a
Wednesday) I would like to have a function that would return 2-11-2008
(Monday). Any ideas?

I have a project that needs to use the autoffilters to select varying line
items. I need to average only the visible cells. I am using the subtotal
function to get the sum of only the visible cells but i also need to get the
average of them as well.

In Excel XP you could just drag the field twice into your Pivot table and
calculate a sum and an average for example; how do you do the same function
in Excel 2007?  I need to get the same data field into my pivot table twice.

I am using Office Excel 2003.  According to the offline Help page, the
second argument of RANK() is (emphasis added):  "an __array__ of, or a
reference to, a list of numbers".  So why does the following result in
a syntax error?

I've got a cell that represents a sequence of numbers like p129-132 and would
like to list each number seperately: p129,p130,p131,p132.
TIA

Dear experts:
On sheet 1 I have a series of dates in order in column 1.  In column 2
is a measure which I enter as the date is reached.  In column 3 is a
formula which uses the number in column 2 to calculate a number.  (In

OK THIS IS WHAT I HAVE SO FAR:
=IF(AND(ISNUMBER(CP5:ED5)=TRUE),"COMPLETE","N/A")
IN CELL A5: CELL VALIDATION DROP DOWN LIST WITH 24 OPTIONAL "PERSONEL TITLES".
I NEED TO BE ABLE TO PUT THE FORUMAL IN CELL J5 SO THAT WHEN REQUIREMENTS

I created a list within Excel and when I select the cell I get the drop down
box which allows me to then select one of the item within the list.
My question is: How can I have the drop-down button show for the cell that
contains the list.  As mentioned, currently it only shows ...

I would like to use the COUNTIF (or SUMIF) only for filtered rows.  Thus
somewhere a SUBTOTAL kind of functionality but for COUNTIF.
Is it possible to simulate (maybe with array formulas)?
Many thanks in anticipation.

Does anyone know how to set up an equation, i assume using the If funtion but
maybe something else to pull from a percentage range.  i cannot set it up to
work properly since it would have to say greater than a number then less than
a number.  Example below.

I have a table of data, which lists details of events.  Column D contains the
date of the event (dd/mm/yyyy). I am using pivot tables to summarise the data
in various ways.  One thing I would like to do is have a pivot table to show
the number of events per region per year.

Hi Everyone,
I have set conditional formatting for a range for column: =MOD(ROW(),2) and
choose grey color, so that the row will appear as one white and the next one
is grey.

I am looking to add more items to a IF statement. The current is:=IF('Week
2'!$E$20="Annual","A",IF('Week 2'!$E$20="Sick","S",IF('Week
2'!$E$20="Personal","PL",IF('Week 2'!$E$20="FLSA Comp","F",IF('Week
2'!$E$20="GA Comp","G",IF('Week 2'!$E$20="Holiday","H",IF('Week

I have a list with dates in fields F5-F50 and want to automatically
populate G5-G50 with a date 6 months future. I am using
=DATE(YEAR(G1),MONTH(G1)+6,DAY(G1)) but how do I get it to progress
through the colums so that G5 picks up the date from F5 and adds 6

I want to insert 2 horizantal lines within one cell. How would I do that? Is
that possible with Excel?