In This Section

How we can use (Exel functions2003.2007) to calculate the diffirense between to date? For example:
01 05 2008
-
04 01 1968
the result is =
27 07 0039

and we now the month should be 30 days not less not more i mean we ignore when the moth is 29 or 28 or 31
the month is 30 days

[tfl - 29 July 08] You should post questions like this to the MSDN Forums at http://forums.microsoft.com/msdn or the MSDN Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quick response using the forums than through the Community Content.

I used a 3d reference as =Sheet1:Sheet3!A1:B5 in the define name box to define a range A1 to B5 Named ABCD1 in any of the defined sheets located between Sheet and Sheet3. The name and the "refers to" are accepted yet the VBA code does not accept the range in the instruction

Range("ABCD1").Select

Any help appreciated.

Thanks,

daniel17363