Format as a Number with no decimal places.


"Ron" wrote:

Thank you Peo,
I changed to your simpler format and now I get the number 36534, how do I
make that the difference of 9 days? I have formatted the cell to a general
number.
Cols
A b c D
5001 01/01/05 01/10/05 36534
Thanks for your help and patience!
--
Ron


"Peo Sjoblom" wrote:

It shouldn't matter the least, a cell with a formula that produces a date or
a hardcoded date would be the same and testing using your fromulas I don't
get an error, my guess is that the source formula somehow gives an error and
an error will always be transferred . Btw there is no need using DATEDIF for
days, a simple =C27-B27 is enough, just format result as general or else you
probably get date format

Regards,

Peo Sjoblom

"Ron" wrote:

I have two columns (B & C) of dates (mm/dd/yy). The first colmn is the result
of converting a Julian Date (col A) to the calendar date, so there is a
formula hidden in cell B under the date. I am using the formula
=DATEDIF(B27,C27,"d") to determine the number of days between the two dates.
This does not work with the two colums in my worksheet that has the hidden
formula. The answer I get is #NAME? (this is the formula behind cell B
=DATE(INT(C3/1000),1,MOD(C3,1000)) ).
If I put a date in col b (not a result of a formula from Col A) and use this
formula(=DATEDIF(B27,C27,"d") ) it works. Example 2
I am guessing the hidden formula is messing up my work?
I am using Excel 2000

EX. 1
Cols
A b c D
5001 01/01/05 01/10/05 #NAME?

Ex 2
A
Blank 01/01/05 01/10/05 9
--
Ron