Eric has attended:
Excel Intermediate course
Excel Advanced course
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Excel Dashboards for Business Intelligence course
Date calculations
When subtracting one date from another, you get the difference between the dates in days. Apart from dividing by 365, is there an exact way of getting the answer to be in years. Or are there any other methods for doing this?
RE: Date calculations
Hi Eric, thanks for the post
You can use the DATEDIF function, The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:
=DATEDIF (Date1,Date2,Interval)
Please note that Date1 must be less than (earlier) or equal to Date2. Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes
Hope that answers your question
Tracy
