• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Date Calcualtion Question :: Years and Months

cubs610

Member
Hi Everyone,

Question for you. I'm trying to figure out how long a person worked at a company to the year and month. For example, they were employed from XX/XX/XXXX date through XX/XX/XXXX date-- how many years and months were they employed- displayed like X years and Y Months, say 7 years and 3 months.

I'm familiar with the DATEDIF function, but am curious as to some other plausible solutions.

Thanks,
Dave
 
One possible option... It's only roughly accurate though given it assumes every month to have 30 days and every year to have 365 days.

Date Difference.png
 
Back
Top