I need to find the number of days between two days, but I need to include the
start date, and not the end date.
For example:
Start: 1/7/08

I am looking for a way to use cells in a spreadsheet as live clocks. I want
to be able to show the live times in multiple cities using the cells in a
spreatsheet. Anyone know if this is possible?

I’m working on a spreadsheet for my payroll, in column
“A” is a weekly pay period end date
“I” is my gross pay for that week
Holiday pay is figured on a weekly average of the last quarter gross pay.

I receive a report which has transaction numbers either 16/17 digits long.  
Is there anyway I can retrieve the full number from excel?
Much appreciated.

I'm using the function below to make a hyperlink.  The contents of 'A-Z
Inputs'!AN5 has a named range in it.
=HYPERLINK('A-Z Inputs'!AN5)
When I click on the hyperlink though, it says, "cannot open the specified

I spent a day trying to merge columns from different sheets into one sheet.
My case is: I have 52 sheets named: 1,2,3,4,5 ...52 with the same format. I
need to copy column A content ( A3:A66 ) from all these sheets into one
column in a sheet "Source" as the content is appended ...

Is there a way to call the AutoFit function of Excel using one of the
macros defined in the XLCALL.h file?
I am trying to do this from inside a VC++ app.
Any help is welcome.

Dave, I just wanted to say thanks.  I was using a shortcut that included the
Shift Key.  The macro works when started from the Macro Menu.
I tried to say thanks in an email (3 times) but they all bounced.  I even
tried adding an 'n' to your address.  However, looking at your ...

What is the NNTP for this newsgroup?
Thanks
EM

Have seen examples similar to what I am asking but my problem is it can be
ANY number. I want to read (from left to right) the contents of a cell and
once I encounter a number, copy the remaining text from that point on.

I want to add a query criteria using the 'begins with' option.
I cannot get the syntax right. Choosing  ---   begins with [xxx]  ----- does
not work.
what should it be?

I have a formula to calculate the percentage of profit on a line
item:  =(F2/G2)
Now I want to make it so that if the percentage falls below 133%, the
cell displays the number in red.  I know this is probably easy for the

I am trying a conditional statement to return "yes" if the date is in 2005.  
I have used this
=IF(M2=YEAR(2005),"yes","") or =IF(M2=YEAR(AA2),"yes","").  The second
statement reference a cell w/ the year.  I do not get any field to be "yes"

I'm tracking data for three products on a master sheet but want to link the
complete row/line item data to individual sheets for each product.

Hi out there
Please I need help with working between worksheets. I have some values in
work sheet 2 which I need to correspond with results in worksheet 1. How do I
go about it