=today()-3/7/2009 = 4?
 

As given above, I tried the function I get 4 when I use custom cell format
as "d", whereas if I don't specify "d" it shows 125. What am I doing wrong?
Thanks

=today()-3/7/2009 = 4?
 

Hi,
have the formula =today() in one cell (A1), let's say that you have the
other date in cell A2, in B2 enter

=A1-A2
format column B as number no decimals

"dindigul" wrote:

As given above, I tried the function I get 4 when I use custom cell format
as "d", whereas if I don't specify "d" it shows 125. What am I doing wrong?
Thanks

=today()-3/7/2009 = 4?
 

The difference between those two dates is indeed 125 days. The number 125 as
a date means Thursday, May 03, 1900. Thursday is the 4th day, that's why you
get 4 if you format as d.
What result did you want?


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"dindigul" wrote in message
...
As given above, I tried the function I get 4 when I use custom cell format
as "d", whereas if I don't specify "d" it shows 125. What am I doing
wrong?
Thanks