Calculating Accrued Vacation Days

[Chas123]

I'm having difficulty with a formula to account for employees accrued vacation days earned. The issue is that each month has different dates and employees have different hire dates, so calculating days earned per month will be prorated depending on when they started. Therefore, I have created a table to the side calculating vacation days earned on a monthly basis- the combination of all months equals the value under the column "Emp Hire Date." The main problem is that future months are populating a full 0.5833 days. Can someone please help me with my formula based on these criteria:

A) Each employee earns 0.5833 vacation days per month.
B) Vacation is earned from the start of the Emp Hire Date but cannot be used until 6 months of employment.
C) Contractors do not receive vacation pay, which is why the value is "FALSE".
Attachment 323020Attachment 323020Copy of Ascendium Vacation Tracking_noname.xlsx
If you have any further questions or comments, please let me know.

ANY HELP IS GREATLY APPRECIATED.

[ThirtyTwo]

what about

Please Login or Register  to view this content.

this checks that the month is less than the date in C1 (todays date), if it is then it will do your formula, if not it will show nothing

[Chas123]

Thank you for your quick response!

The issue I still face with your formula is that if you input "7/21/2014" in cell C1, it still populates a full .5833 when the employee has technically earned all of that months vacation. It should be prorated.

[Chas123]

Excuse my previous statement. What I meant to say was: "The issue I still face with your formula is that if you input "7/21/2014" in cell C1, it still populates a full .5833 in cell V6 when the employee technically HASN'T earned all of that months vacation. It should be prorated."

I hope what I'm saying is not too confusing, but the entire formula works except when you encounter mid dates of the month. It will not prorate the .5833- either it is a full .5833 once the month has completed or it is blank if the month has not been completed.