need custom WORKDAY function or the like
Posted by Tony on August 07, 2001 9:27 AM
I use the WORKDAY function to forecast days for regular Mon-Fri employees. ex.=WORKDAY(DATE(2001,1,1),50)will return the 50th workday from 1/1/01 excluding Sat&Sun dates.
I now have employees who work Saturdays and have another weekday off instead. Kicking around some ideas, but don't want to build long lists of dates with vlookups and yes/no flags. Would like to create something that would work in various weekly work schedules.