Tuesday, March 13, 2012

yogi_Select Dates For Only Specified Weekdays From A Range of From And To Dates

Yogi Anand, D.Eng, P.E.                Google Spreadsheet          Post  #467          www.energyefficientbuild.com

user stroh.ed said: Workday Formula Shift I'm working on developing a scheduler for the company I work for. The section I'm working on has to do with turnaround dates for orders of different sizes. As of right now the formula for calculating the due date looks like the following: =WORKDAY(NOW(),D2+ROUNDUP((FlightPanel!H3))) (FlightPanel!H3 is a backlog modifier to adjust the date to be further out based on workload) The problem at the moment is that this method only gives me due dates for weekdays but the nature of the work permits due dates on Saturdays but not Sundays or Mondays. Is anyone aware of a way to make the formula permit only dates including and between Tuesday and Saturday? Any help would be greatly appreciated. 
-----------------------------------------------
following is a solution to the problem of selecting dates for only specified weekdays from a range of from and to dates