I have the following formula
=IF(ISBLANK($O8),NA(),YEAR($O8))
$O8:  12/28/2005   which is interpreted by the formula as 38714
I'm getting 1905 as a result.  

I have a macro (below) that should loop through a catalog and for
every file copy and paste each sheet. But it only takes one of four
sheets and copies that four times. I have tried all options but are
stuck. All help are appreciated.

how can i do this? eg. I start a job at 8am, I needed 2.8 hours to complete
the job, how do I add the [2.8 hrs] to [8am] to obtain an expected completion
time?
completion hour can show either in 12 or 24 hours time format.

I've formated some cells so the read 0001, 0002 ect.  This is how i'd like
the data to show when i export in a mail merge but at precent i can only get
it to merge 1,2 ect.  Dose anyone know how to set it up so it reads all
digets as data?

I have a spreadsheet with column, Date, Name, Amount. only a few columns, but
a few thousand rows with same Name, different Date and different Amount.
Sample below:
Date        Name         Amount

In the criteria section of the SumIF function I would like to look for text
in the range of cells than contains a word or words.  I know how to look for
a single word, but do not how to look at a text string that contains certain
text

I am currently using the following formula:
=IF(COUNTIF(E:E,E5)>1,"Duplicate","")
Basically it is entering Duplicate in a cell if an address appears twice. My
problem is this, our HR department has changed there reports procdure. Now

i am trying to get excel to round down (instead of round up) the result of
the following formula:
=IF((100-(((I2)-0.75)*144))>100,100,(100-(((I2)-0.75)*144))). the input in I2
is 21:24, which is in the [h]:mm format. The answer is 79.6, but excel will

I have 13 columns of data 1-12mths the first column calculates the totals of
mths 1 to 12.  When I entre data say the 1st 4mths I need the 1st colum to
read the total actal spend and average so we can predict over/under spend
befor the year end.  This bit I have achieved.  ...

My problem is: I use a very large
formula:=SUMPRODUCT(--(TEXT(F13:F59,"yyyymmm")="2007Jan"),J13:J59). and the
formula is used in more than 1000 cells. but the month name and range changes
according to row and column of every cell. How can I change the formula of

I currently use Office 2003. Is there a format i can set up for cells where i
can type in just 4 characters for a time, say 0845 for 8:45 AM without having
to type in the : colon or the "AM". I have set up formats for numbers
generally, but can't seem to get this working. I have ...

I want to pass on cell value of A1 into VB script every time i run a macro
which command should i use?

First here below my example in order to be understood easily
Database:
Stock ticker   Quantity     Buy/Sell
HRHO         1000        Buy

I have two Columns namely Received Date & Time and Updated Date & Time.  I
want to calculate the number of hours taken in between the received and
updated.  
The problem i have is

Hi,
I need to count with two parameters, but I can't get it to work in excel 2003.
I'm using Excel 2007 and the CountIFS command, and that is working, but when
I want to save the file as 97-2003 it pops up with Error on the formular.