Need help with a formula

[cygmark]

Hello Guys im new to the forum,

i have a tricky question, I need a formula for my excel sheet. What im trying to create is a formula to count the days since a lost time accident, so an equation from 1 date to another....simple right.....except...i want it to count monday-saturday and one equation to count only mon-fri...


can this be done...???

any help would be greatly appericiated.

thanks Josh

 

[cygmark]

Ahhh, i think i got it, if anyone can verify to make sure this is correct

=networkdays(A1,today())

i forgot the brackets inside and it works i think.


thanks all

 

[Scott Huish]

Looks good!