I need to have a date column that contains a date that is 3 workdays from the
date specified in another column ("date submitted").
Right now it's set to give me 3 days from the date in the submission column
but I need to have it skip weekend dates in its calculation.

Using Excel 97.  I know it's old, but it has always worked just fine and
does everything I need to do.
Have two problems:
a.  I have a column of numbers, and formatted as such.

I have a macro which when run removes a couple of excess lines from a
report (produced from elsewhere). The excess lines appear depending on
what time of the day the report runs.
When I run the macro, the links on the second sheet are recalculating,

I am sure this is probably simple but here goes:
I have put together a sheet that records my blood sugar levels over a
month. I am using the sheet to calculate averages for different times
of the day and under different circumstances.

Hi Group,
I have an Excel 2000 workbook which I am getting reports of worksheets
missing.
The workbook has custom menus and the delete worksheet option is not

I am using Excel 2000 and XP.  I have just learnt how to use an .iqy
file to extract data from the web.  To really benefit from automation
I want to create a loop using slightly different web adresses each
time. I have recorded the query as a macro and get:

I am struggling with this:
I have a Column of integer values, say: A1: A100
I want to sum the first three values at one time, say sum(A1:A3), then
sum the next 3 values: sum(A2:A4), then the next 3: (A3:A5), and so on

I have four columns to combine and I use the concatenate function.  One of my
columns has either 3,4 or 5 characters.  When I concatenate, there are spaces
in the middle of the end product.
How do I get those spaces to disappear in column 1?  I can't just set the

In col E I have numbers from row 1 to row 22
How do I find out the MAX(the highest) number between row 1 and 10 or row 12
and 22
Thanks

Although a newbie to macros, I attempted a record macro in a sheet I was
developing, and made a mess of  it. I went to delete it by going to tools,
macros, list in this sheet, and delete. However, the delete button is grayed
out. Now each time I open the workbook excel tells me ...

I am using Excel 2003.
I have a protected sheet that allows the user to enter quantities in only 1
column.  All other cells are locked.
I have a control button that has code that uses the "Autofilter" statement.  

Hi, can anyone help please. I have a problem with a workbook I have done to
track absences at work. We use the Bradford system which is S S D. The first
S being the amount of times a person is absent, the second S is multiplied
by the first and finally the D is the number of days ...

   I have four work sheets that has data for the last four years.  (one
sheet for each year)  I made a new worksheet and want to create a Line Graph
that will graph the data from the oldest year to the current year.  Excel is
not letting me select multiple work sheets.  Can this ...

I'm up for a new job and I qualify in every area except one... Excel. I have
good understanding of basic Excel features (I can build simple spreadsheets
and workbooks) but I need to expand this a great deal to have any chance for
the job (more advanced formulas, integrating with ...

I some how set all the cells in my excel workbooks to put a hyphen before
text I type in - This is now afecting my hyper links - I dont remember how I
did it and cant turn it off. Can someone help????