How do I add "accrued vacation days" column to the Employee Attend

[Jam]

I found the template for the Employee Attendance Record, and it's the one I
need, but I also need to add a column for "accrued vacation days" (monthly).
How do I do that?

 

[Gord Dibben]

There are a few of these templates at the Template Gallery.

If you share the URL of the template you downloaded someone could probably help
you.

But I would imagine you just insert a column and go from there with formulas to
calculate accrued days based upon some algorithm which you would know.


Gord Dibben MS Excel MVP

 

[Jam]

This is the link to the template that I was referring to.

http://office.microsoft.com/en-us/templates/TC012291251033.aspx?CategoryID=CT012261941033

I know how to insert a column, but not familiar on how to make it to
calculate the accrued vacation day per month (for ex. employee entitled to 10
vacation days per year, accrued monthly at the rate of 0.833 days). Does
someone know how I could do that?

 

[Gord Dibben]

In accrued vacation column(new column) enter this formula

=DATEDIF(I6,TODAY(),"m")*0.833

Drag/copy down as required. Format to General or Number

Note: On the Template, column I is hire date.


Gord

 

[Jam]

Thank you Gord.

In accrued vacation column(new column) enter this formula

=DATEDIF(I6,TODAY(),"m")*0.833

Drag/copy down as required. Format to General or Number

Note: On the Template, column I is hire date.


Gord