[SilviaG]

What is the best way to make a spreadsheet that tracks accrued vacation per
day?

[JE McGimpsey]

"Best" often depends on the situation, but one of the simplest ways:

A1: <start date
A2: <accrual per day
A3: =(TODAY() - A1) * A2




In article ,
SilviaG wrote:

What is the best way to make a spreadsheet that tracks accrued vacation per
day?

[SilviaG]

But that includes days that are not worked. Our company accrues .0192 for
each day worked, not including weekend. is there a way in which we can do
that without counting the weekends

"JE McGimpsey" wrote:

"Best" often depends on the situation, but one of the simplest ways:

A1: <start date
A2: <accrual per day
A3: =(TODAY() - A1) * A2




In article ,
SilviaG wrote:

What is the best way to make a spreadsheet that tracks accrued vacation per
day?

[David Biddulph[_2_]]

The function you need is NETWORKDAYS. Look it up in Excel help.
--
David Biddulph

"SilviaG" wrote in message
...
But that includes days that are not worked. Our company accrues .0192 for
each day worked, not including weekend. is there a way in which we can do
that without counting the weekends

"JE McGimpsey" wrote:

"Best" often depends on the situation, but one of the simplest ways:

A1: <start date
A2: <accrual per day
A3: =(TODAY() - A1) * A2




In article ,
SilviaG wrote:

What is the best way to make a spreadsheet that tracks accrued vacation
per
day?

[JE McGimpsey]

But you asked for "accrued vacation per day" not "accrued vacation per
worked day".

FWIW, that's why I qualified my answer re "best" - I've worked for
companies that accrued vacation per calendar day, per work day, per
workED day, per 4-hour-half-worked-day, per full month, per partial
month, and per annum. And there are many other schemes out there.

You can use NETWORKDAYS() to eliminate weekends (and holidays?).

Does vacation accrue on a non-worked work day (e.g., when on vacation)?
If so, you'll need to take that into account somehow.




In article ,
SilviaG wrote:

But that includes days that are not worked. Our company accrues .0192 for
each day worked, not including weekend. is there a way in which we can do
that without counting the weekends