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

  • Thread starter Thread starter dindigul
  • Start date Start date
D

dindigul

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
 
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
 
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?
 
Back
Top