Excel: Formula to find the next Monday, Wednesday or Friday?

So I have a set date, let's say 17/08/2014, and I want the cell next to it to return the next Monday, Wednesday or Friday depending on which is next. Obviously it would return the 18/08/2014. Then if the date was 18/08/2014 (or a Monday or Tuesday) I'd need it to find the next Wednesday, and so on for Friday. Is there any way to do this?

This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of August 18, 2014.

For more resources for Microsoft Excel