does anyone know how i can retrieve trading days only from a list of dates
and codes that are returned (1 or 0) when the date is not a holiday or
weekend/

I would like to know how to create a summary sheet for a workbook, for
example if I create worksheets for 3 branches of a company with the same
headings and formulas, how do I do a total summary sheet for all three
together?

Hello fellow helpers,
I wrote the following formula to fill in the direction for a help request
(there are two teams working on the helpdesk) that I thought would fill in
the cell once the corresponding drop-down list was filled in (cell h3).  It

I want to set up a formula that will search for multiple values within
a cell, and then return a value according to the findings.
For example
3 cells may contain the following text:-

I have some data that I want to extract a number from.  Here is an
example.
ABSD (P+3.9%)
I want to get at the 3.9, and I'm assuming I would want to use the "+"

I am creating a if/then formula that will look at a cell in column A that
contains either one of the following day notations MON, TUE, WED, THU, FRI,
SAT, SUN, or HOL.  If the date is between any non holiday weekday it should
be included in a count.  The second part of the ...

Had a look in the tips for this one, thought it might be to do with
dynamic range summing, but still can't work it out
I have a sheet detailing auction sales. Some days have more than one
auction sale, other days have no auction sales.

I'm trying to calculate the number of resource days needed for a variety of
events which are either 0.5, 1 or 2 days long.    The event length is in
Column J.
The events are each for 8 people, so I can calculate the approximate number

There are no formula apparent and this occurs on all new worksheets and even
after reloading the software.  The number 3 input appears as 0.03 and so on.

How can I match 2 columns ?
a1           b1                                               a2         b2  
          c 2          d2
001        un801                                           lala        un801

Gentle people
I'm a beginner... real  beginner .. and I have this problem
I have two inpuBox with two questions about the amount of materials ( eg.
amount of Material A and Amount of Material B)

I need to replace the value in A1 with the entered value in B1. eg, A1=20;
B1=20 now I type 30 into B1 and A1=50. Is this at all posibble? Please help?

Hey All,
I require a worksheet function or group of function that will allow me to
convert my dates of format dd/mm/yyyy to Week 1,  Week 2,  Week 3, Week 4.  
Hope someone can help.

Need a formula to average a range of cells but only if there are numbers
so I dont get a zero.
=AVERAGE(IF(E8:N8,E8:N8)) this is what I'v tried but I just get
#VALUE!

I keep a series of worksheets for weekly sales results that contain sales
results from Last year and entry points for comparison for sales for this
year eg
wk 1             Wk2             wk3           Wk4           Period to date