Will not work since it will return the day of the month 63 days after Jan 00
1900
use something like this instead

=INT(NOW()-A1)&" Days "&TEXT(MOD(NOW()-A1,1),"hh")&" Hours"


--
Regards,

Peo Sjoblom




"Steve" ;sfcmurphy430@hotma il.com wrote in
message ...
Sorry for not providing all the info, the result of the calcualtion I have
as
custom, (dd "Days," hh" Hours"), so it shows how many days and hours have
passed since the fixed date and time.

"Peo Sjoblom" wrote:

1. If you are comparing days and not hours etc don't use NOW(), use
TODAY()

2 format the result as general

If I do that I get 63

=TODAY()-A2

where A2 holds 04/16/07

formatted as general


--
Regards,

Peo Sjoblom


"Steve" ;sfcmurphy430@hotma il.com wrote
in
message ...
I have a status spreadsheet that counts how many days from a fixed date
to
Now(), in one field the date is 16 April 2007, to Now() it is saying it
is
3
days, when I move it to a different fixed date of 19 april it tells me
23
days, it should read 60 on 16 april and 57 on the 19 april. I have
checked
the formating, and on some it counts properly.

Has anyone encountered this before if so please tell me how to fix
it...
Thank you Steve...