I have a start date field in a table, I need to calculate a completion date that is 6 months later but it must also be a Friday. I know how to calculate the 6 months part but I don't know how to advance the date to a Friday. For instance if the start date is 4/15/13 then the completion date must be 10/18/13.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!