Friends,
I am looking for formula to calculate the dates between two days
(excluding the weekends)
I am working in Saudi Arabia and the weekend days over here are

I have this requirement where I am required to find the total number of
entries that meet critieria in three columns. I have used the below
listed formula to realize that :-
=SUMPRODUCT((INDEX(WE_20060319,,10)="NN01")*(INDEX(WE_20060319,,5)=1)*(((INDEX(WE_20060319, ...

I need to derive a value in a cell by formula, and then hold that valu
somewhere unchanged when the input values are later updated.  Is thi
possible
--

Working on a log and would like Excel to find the department number and enter
it into the cell next to name when name is entered into the log.  Have
created a list with names in column "A" and department #'s in column "B" .
Sheet 1 named Log

Hoping someone can help, I'm about to lose my mind.  I've tried every
combination of sum, if, countif, sumproduct, you name it and I can't
figure it out.
I've got a column of dates.  What I want to do is count the number of

I have 4 seperate columns in one worksheet which I have create seperate
pivot tabels for, I would like the columns corresponding to the pivot table
to be dynamic. Do I make seperate Name for each set of data like below or can
I make one Name capturing all the data.

In Sheets 1-8 I have calendars for different people w/ 8 on days they
have off
In Sheet9 I have in Column A days 1-31
In column B I have:  =IF(Carlos!B3=8,"Carlos")

Is there a simple formula in Excel to invert text?

I cannot find invoice toolbar

i was working a formula in excel and i mistakenly hit a key which caused a
spade ( a la diamonds, hearts, clubs, spades) to appear. Can someone tell me
what this represents and how i managed to makee this sign appear.

Please help, What is the command to run a macro from an IF condition. The
macro is called MacroB so:    IF(K39=60,run macro,stop) from the programming
format of: if cell K39 =60 the run the macro else stop. Thank you

Can I run a macro from a cell function in Excel 2003 with the idea of
comparing 1 value against another and if its true, it gets highlighted yellow?
Thanks

i need to know, how much people belongs to the number in Colum A - if in
colum C is written "ISM".
  A B            C    
1 1 Meier      ISM

I have an extensive list of addresses -- provided format is 'streetname,###'
(notice comma),  I need addresses in format '### streetname' (notice space).
An example would be 'Washington,1909' and desired outcome would be '1909
Washington' I'd appreciate any suggestions for ...

I need to keep track of weekly bug counts on a periodic basis.Her
is an example
Date logged      P1 bugs     P2 bugs   Week Logged(Sunday)
[To be calculate