About Us

Jean-Jérôme Doucet via OfficeKB.com

Hi,

I want to subtract two dates 'YYYYY-MM-DD' but by doing in VBA and pointing
to their respective cells and dump the result in another cell.

For example, I am working on this experiment :

Quote:

Sub datescalcul()
Dim Baux As Double
Baux = Application.DATEDIF(Worksheets("Formulaire").Range ("I16").Value,
Worksheets("Formulaire").Range("J16").Value, "m") / 12
sheets("Formulaire").Range("K16").Value = Baux
End Sub

But it does not work. Maye it is that dateDif Excel function cannot be
converted in VBA function?
Thx!

JJD

--
Message posted via http://www.officekb.com

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Subtracting Dates	Dilly	Excel Discussion (Misc queries)	10	January 28th 08 04:00 PM
Subtracting Dates	jaxstraww	Excel Discussion (Misc queries)	0	March 28th 07 01:58 AM
Subtracting Dates	jaxstraww	Excel Discussion (Misc queries)	0	March 28th 07 01:56 AM
Subtracting dates	toot033	Excel Discussion (Misc queries)	3	July 17th 06 09:03 PM
Subtracting Dates	sam	Excel Discussion (Misc queries)	3	March 2nd 06 12:47 PM

Menu

About Us