Exact Difference of Two Dates

**kmrz** · 10-08-2019, 10:14 PM

Hi there,

Need your expertise in getting the exact difference between two dates. I am currently using =YEARFRAC(C4,C5)*12.

Assuming:

C4 = Start Date
C5 = End Date or As of Date

To give you a brief context, our employees are entitled to 12.5 hours per month. I tried calculating the accrual for two different dates in the same month (e.g. 01 March 2019 to 09 March 2019 and 10 March 2019 to 31 March 2019) but I got 3.33 hours and 8.75 hours respectively which is a bit short for 12.5 hours.

**Pepe Le Mokko** · 10-09-2019, 02:41 AM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**kmrz** · 10-09-2019, 04:55 AM

Sample workbook attached

**Gregb11** · 10-09-2019, 10:41 PM

I think the reason you're not getting the exact numbers you're expecting (12.5 hours/month) is because each month is not equal in days. If you take the 9 days (from Mar 1 to Mar 9) and divide that by 31 (days in March), and multiply by 12.5, you get 3.63. And then from Mar 10 - Mar 31, you get 22/31=8.87. 3.63 + 8.87 = 12.50.