ThomasBallardIT
asked on
day of the year - weekends
I used the days360(#1/1/2006#, maximum({InvMovements.Entr yDate})) to get the day of the year. I need a formula or something to exclude weekends. Any ideas?
Thanks for any help.
Thanks for any help.
ASKER
I don't need to deal with holidays, could you simplify that formula a bit.
I'm not much at using variables, but if thats the best way then I will do it.
I'm not much at using variables, but if thats the best way then I will do it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can get the number of workdays between 2 dayes using the formula here:
http://kenhamady.com/form01.shtml
Pete