how do we get the date count? I'm aware that this you could use thi
05/05/05 - 01/05/05= 4days
*BUT* i need to work out the date to count on day one e.g 01/05/0
including weekend so i tried this 05/05/05 -01/05/05+1=5, works wel

I have one sheet with data looking like:
package no.   name        costs
0.1                A              50
0.2                B              100

Hey guys
How can I make the following formula work =(B3+C3+D3)*E3*F3?  I need the
numbers in brackets to be multiplied by E3 and then that number multiplied by
F3, what am I doing wrong?

Hi Guys
I need a function or a formula which can do the following......
I have two worksheets.
One worksheet has a list of names in a set order that can't b

I have the following array formula that works correctly as long as th
range
I16:I39 has data in it; however there may be times when cells in tha
range are set to blank via another formula.  When this happens, I ge

Help!!!  I can't workout how to do an overtime calculation if a standard
day was 7.5 hours (7 1/2 hours) and they work on a bank hol I want it to
state that they have worked double time in hours worked that day??

I named a group of cells "northwest" which contains sales data.  I could  sum
the sales data with a formula =sum(northwest).  Is there a way to sum the
sales data with a formula =sum(A2) where cell A2 contains the text
"northwest"?

Hi Experts;
I want to hide Sheet tab Bar & status Bar for a excel file and this
should remain with that file only, not for all files.
Please help me.

ok Please can you help me here goes
I have a table showing this data
1    2   3   4  5  6   7
aa gyn c att 23 22 21

I want to know the formula in excel work sheet for converting the  digits i.e
123 to words i.e  one hundred twenty three automatic in english or hindi
language also in MS words. I know in THAI lang the formula is " BHATTEXT(Cell
No)

OK here goes:
In a data sheet (sheet 1) I have the following columns:
A: Qty
B: ItemType1

Why doesn't the following formula work?  =count(if(k2:k20,"1",j2:j20,"<40"))

Hi Experts....heres one query.
In excel, the comma (to the figures) is put as per the American System. i.e.
if I want 100000. It will be shown as 100,000.
Is there any way by which I can get it as 1,00,000.

I have a worksheet created that has "D" to represent Dayshift and "N" to
represent the nightshift. I would like to create a formula in the total cell
on the nightshift worksheet that would indicate the total for both worksheets
that have any nightshift personnel. Here is the ...

I have a workbook where in sheet 1 there is a list of items (such as apple,
pear, orange).  In sheet 2 these items are listed with various prices.  How
can I set up a formula that will take each item in the list in sheet 1 and
find all the matches in sheet 2 and then determine ...