Re: calculate month
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
On Fri, 6 Jan 2006 07:26:02 -0800, "RJ" <RJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>How can I calculate the number of months (or years) between two dates, such as
>06/11/2000 and 09/20/2005?
=DATEDIF(start_date,end_date,"m")
--> 63 with your data.
Of course, you have to be aware that when you are dealing with dates near the
end of the month, and the end_date month does not have as many days, you may
get unexpected answers.
For example:
start_date 29 Jan 2006, 30 Jan 2006 or 31 Jan 2006
end_date: 28 Feb 2006
Result: 0 months
Depending on exactly what you want, this may or may not be adequate.
--ron
.
Relevant Pages
- Re: I have a question
... They are leveling between adequate, depending on dependent, due to ... If you'll enable Pervez's left with variants, ... Some minerals sentence, require, and contract. ...
(sci.crypt) - Re: Consistent Moral Standards
... other U.S. law-enforcement bodies are adequate to dealing with that ... Abortion, which is legal in all of the US, is unavailable in much if it ... I don't call that dealing with it adequately. ...
(rec.arts.sf.written) - Re: How to determine source of opened form
... Brendan Reynolds (MVP) ... I have a procedure that I wish to run depending on which form was used ... Prev by Date: ...
(microsoft.public.access.formscoding) - Re: Bound for cosine integral: |Ci(x)| < 1/x ?
... -> infinity. ... Note that Ciis the real part (depending on how you define it ... Show that the absolute value of the remainder after n terms is less ... ..but i don't know if that makes sense when dealing with an asymptotic ...
(sci.math) - Re: Bound for cosine integral: |Ci(x)| < 1/x ?
... -> infinity. ... Note that Ciis the real part (depending on how you define it ... Show that the absolute value of the remainder after n terms is less ... something other than zero otherwise we are dealing with an exact ...
(sci.math) |
|
