I have two problems with the format of two different columns of dates i have
coppied onto an excel sheet. I need to be able to have the dates in a
standard date format in order to be able to work with them. The problems are
as follows:

I am struggling with an IF Statement in Excel. I want to have a sheet which
says if it is mon -thurs add these totals and if it is Friday add these
totals together.
Does anyone know a way around this

I want to display in my pivot table report data fields which have no value
yet but I dont want those fields to up as "blank", instead they need to be
displayed empty as in the database.  How do I accomplish that ? I have tried
formating them via table options checkbos for empty ...

mHi,
I need to compare two columns of account numbers that come from diferent
sources. One column has the account number correctly displayed, the other has
extra zeros added in front of the origial account number - some numbers have

The Data that I use for my pivot table keep changing each week. Weekly,  I
copy and paste data from another excel spreadsheet into the workbook that
contains the pivot table. Each week I go in and rename the data range before
I refresh the data. Is there a way that I can perform ...

I'm struggling with an array formula that will return the SUM of the
Top 20 values in a list that meet a given criteria.
E.g. SUM the Top 20 instances of Dog.
Condition Field            Data Field

I am trying to count and cells that have a number "11" in the cell and is
colored red.
The following formula, will count all cells that are red... but I only want
it to look at the cells with the "11".  How do I do that?

I have a task spreadsheet that needs to be updated by many users.  The
spreadsheet is in shared mode.
How do I get the spreadsheet to automatically filter by the user Id on
opening the file?

Is it possible to have a recorded Macro appear as soon as the Excel document
is opened? If yes, how?

I know how to print the row and column headings.
What I have are several pages of data, and I would like to print the row
labels so the numbers are continous.
For example, if the first page ends with row 25, I would like the second

I have a spredsheet with 100 identical sheets, and I like to lock/protect all
the sheets. Is it possible to do this in a simple way instead of that I have
to lock each of them.

Dear Sir,
May I know how to restore  the grid lines in a page that was lost due to
cutting and pasting block of data ?
Thanks

I have a file name Emplyoee Database which has sheets Add Data, Delete Data,
Edit Data and Master Database.  Where the Add data will add Emplyoee name,
address and phone no. to the related fields in the Master database the Delete
Data and Edit data will find the records from the ...

How do I sum the adjacent 4 columns into a cell? I want an cell to always sum
the 4 cells to the left, allowing for me inserting a new column each week,
ie. a rolling answer.
Any help greatly appreciated.

How do I filter the contents of a table using one cell.  I dont want to use
auto filter as I only want the user to be able to filter on one column.  I'll
explain, I have a table with months in.  Following the months are lots of
other info. In cell A1 I want the user to choose one ...