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