[RESOLVED] hwo to show only date

**kamakshi** · Oct 8th, 2009, 12:32 PM

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

**Siddharth Rout** · Oct 8th, 2009, 01:12 PM

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

**kamakshi** · Oct 8th, 2009, 01:15 PM

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

**Siddharth Rout** · Oct 8th, 2009, 01:19 PM

Go through my previous post once again

**kamakshi** · Oct 8th, 2009, 04:45 PM

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

**kamakshi** · Oct 8th, 2009, 04:56 PM

assume c20 has date for example 10/5/2009

**kamakshi** · Oct 8th, 2009, 05:04 PM

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

**Siddharth Rout** · Oct 8th, 2009, 05:06 PM

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

**kamakshi** · Oct 8th, 2009, 05:09 PM

kool thansk for helpint me
in vba

**Siddharth Rout** · Oct 8th, 2009, 05:10 PM

In VBA

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

In Excel WorkSheet

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

**kamakshi** · Oct 8th, 2009, 05:14 PM

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

**kamakshi** · Oct 8th, 2009, 05:16 PM

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

**kamakshi** · Oct 8th, 2009, 05:29 PM

ITS WORKING GREAT. THANSK kool!

Thread: [RESOLVED] hwo to show only date

Thread Tools

Display

[RESOLVED] hwo to show only date

Re: hwo to show only date

Re: hwo to show only date

Re: hwo to show only date

Re: hwo to show only date

Re: hwo to show only date

Re: hwo to show only date

Re: hwo to show only date

Re: hwo to show only date

Re: hwo to show only date

Re: hwo to show only date

Re: hwo to show only date

Re: hwo to show only date

Posting Permissions