Completion Date

J

Julie Gilliam

I need a completion date to always fall on a Friday if the completion date is
a Saturday or Sunday. Can someone please give me the correct formula to
enter to get the results like this. I have to use a formula to add 90 days
from last completion date and I achieve this by saying [Completion Date]+90
but I need to add something else to the formula so if it falls on a Weekend
Day it defaults back to Friday. I have been trying several years to get this
accomplished. (Before I was aware of this great help) Thanks Julie
 
G

Gary

Your simplest answer is to add 91 dayx. (That's divisible by 7.) You'll still have to manually check for NY, Xmas & other holidays.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top