S
SilviaG
What is the best way to make a spreadsheet that tracks accrued vacation per
day?
day?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
A1: <start date>
A2: <accrual per day>
A3: =(TODAY() - A1) * A2
S
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
each day worked, not including weekend. is there a way in which we can do
that without counting the weekends
D
David Biddulph
The function you need is NETWORKDAYS. Look it up in Excel help.
J
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.
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.