I have been using the workday function for scheduling, but now we have accelerated to a 6-day workweek. Is there a way I can define the workweek?
thanks for the help
I have been using the workday function for scheduling, but now we have accelerated to a 6-day workweek. Is there a way I can define the workweek?
thanks for the help
lblake25,
Try,
=IF(WEEKDAY(A1,1)=6,WORKDAY(A1,1)-2,WORKDAY(A1,1))
Where A1 is your start date. This assumes that your 6 day week is M-Sat.
HTH
Steve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks