Posted to microsoft.public.excel.programming

Brad

external usenet poster

Posts: 846

DateDiff() problem

Excel 2007 (with compatibility to 2003

Sub CalcAge()
Range("IssAgeP").Value = DateDiff("yyyy", Range("C7").Value,
Range("c5").Value)
End Sub

C7 = 8/4/1962
C5 = 2/4/2009

Expect to get 46, getting 47 - Is the problem with using Range().value?
--
Wag more, bark less

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
datediff help	ina	Excel Programming	4	April 24th 06 09:44 AM
DateDIFF	Paul Breslin	Excel Programming	1	December 12th 05 03:09 PM
Help with datediff vba	John	Excel Programming	4	February 16th 05 01:56 PM
DateDiff("w") -- problem	zSplash	Excel Programming	9	January 4th 04 10:56 PM
DateDiff problem	Antje Crawford	Excel Programming	3	July 8th 03 09:44 PM

All times are GMT +1. The time now is 07:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us