Using Excel 2003.  What function or formula would I use in Cell C1 to get
the count number of days between these two dates.  If the time in Cell A1 is
PM, we don't want that day counted.
Cell A1

Can Format/Cells/Number/Custom be used to make a date show the month name in
all caps?
I am using an HLOOKUP to drive several report fields which are based on the
first day of a month.

How can I sort my spreadsheet by 4 columns.  Do I have to use a macro? If so
does anyone have an efficient macro to sort more than 3 columns?
Dan

I have a formula in cell H21, for example, reads like this:
=IF($G21<>"",($H20-$G21),"")
is there a way to adjust the formula so that an empty cell in G21 doesn't
give the #VALUE! in subsequent cells in column H?

i have a spreadsheet with columns ( Vender, Month, Amount ) i'm trying to set
up my table as follows: Column Fields are MONTH, Row Fields are Vender, and
Data Items are AMOUNT. But when i put the AMOUNT in it changes to something
like 1,2,3,4,5. How do i keep my AMOUNT as ...

Does Excel allow "Contours" graphing? If so, how please? Any online
reference?
Thanks,
Mike

I need help with an array formula,
I have to columns, I need to find the min, the max and average form the
two columns added, but I cant create a new column.
E.g.;

      the third 'If' statement is supposed to count all of the dates in the
7th column & not the blank cells. Any idea why it won't work (returns a
result of '0') Like I said before, novice!
                                    Cheers.

I've had a go and created a couple of additions to the menu bar using
VBA.  Some of the captions are based on a cell ref which contains a
variable date in text form.  I need to call my menu procedure when the
cell contents that I have refrenced to change (a new date is entered),

how to add into the formula how to not include cells missing information so
that it does take those cells into account when calculating the average in
cell C1?

I am making a form in the first 50 r&c's of varing hieghts and
thicknesses....no problem so far.
it is only when i want to copy and paste them (even directly below or next
to!!!!!)....the newly pasted ones want to go to some type of default size.

The Excel Function Dictionary is back on a web site.
www.xlfdic.com
It's still free. (Its still the same!)
Thanks to all who still fly the flag for the old file.

I have data in an excel cell setup as follows:
unimportantData, dataToBeExtracted, unimportantData2, unimportantData3
I would like to extract the information "dataToBeExtracted", and had
considered using the MID function.  However, the string length of

Hello Experts,
I'm trying to copy/paste data between two excel docs.  I need to use
the paste special option; however, every time I try to use paste
special, I get the other paste special option (as if the data is coming

 I would like to protect Excel worksheet for all users. So that all users
can't change the Excel content, but can insert comments.
 How can I do this? Thanks