[RESOLVED] hwo to show only date

fro example i have 10/09/2009 and 10/08/2009
i need only date 1 which 09-08 = 1
how dto do that

I can give you the answer but I want you to give it a try :)

Use the datediff function. Search the forums on how to use thsi function or check the help file...

If you get stuck, simply post the code that you tried and we will definitely help you :)

Myday1 = TODAY() - Myday
Myday1.NumberFormat = "0"

Go through my previous post once again :)

i tried this way. it is not coming the integer part
=datediff("dd",TODAY()-C20)
but i dont have time i have only date.
but it is not coming. could you help me

assume c20 has date for example 10/5/2009

i tried this way. it is not coming the integer part
=datediff("dd",TODAY()-C20)
but i dont have time i have only date.
but it is not coming. could you help me

Do you want to use it as a formula in a worksheet or in vba?

kool thansk for helpint me
in vba

In VBA

MsgBox DateDiff("d", Range("C20").Value, Now)

In Excel WorkSheet

=DATEDIF(C20,TODAY(),"d")

now shows the date and time
and c20 value has only date
how it will give date as integer part. coudl you explain.

it shows integer numbe rof 40094
i need the differnce of the date

ITS WORKING GREAT. THANSK kool!