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?

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


On Sun, 3 Feb 2008 11:03:00 -0800, Jam wrote:

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?

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

http://office.microsoft.com/en-us/te...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" wrote:

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


On Sun, 3 Feb 2008 11:03:00 -0800, Jam wrote:

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?

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


On Sun, 3 Feb 2008 23:11:00 -0800, Jam wrote:

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

http://office.microsoft.com/en-us/te...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" wrote:

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


On Sun, 3 Feb 2008 11:03:00 -0800, Jam wrote:

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?

Thank you Gord.

"Gord Dibben" wrote:

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


On Sun, 3 Feb 2008 23:11:00 -0800, Jam wrote:

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

http://office.microsoft.com/en-us/te...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" wrote:

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


On Sun, 3 Feb 2008 11:03:00 -0800, Jam wrote:

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?