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?