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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jam - 03 Feb 2008 19:03 GMT

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?

Reply to this Message

Gord Dibben - 03 Feb 2008 19:54 GMT

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

>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?

Reply to this Message

Jam - 04 Feb 2008 07:11 GMT

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

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

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?

> There are a few of these templates at the Template Gallery.
>
[quoted text clipped - 9 lines]
> >need, but I also need to add a column for "accrued vacation days" (monthly).
> >How do I do that?

Reply to this Message

Gord Dibben - 04 Feb 2008 19:03 GMT

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

>This is the link to the template that I was referring to.
>
[quoted text clipped - 18 lines]
>> >need, but I also need to add a column for "accrued vacation days" (monthly).
>> >How do I do that?

Reply to this Message

Jam - 05 Feb 2008 06:06 GMT

Thank you Gord.

> In accrued vacation column(new column) enter this formula
>
[quoted text clipped - 28 lines]
> >> >need, but I also need to add a column for "accrued vacation days" (monthly).
> >> >How do I do that?

Reply to this Message