Formula to Find the Next Monday

[jmischel]

I have a date in A1. I need to calculate the next Monday based on the date in A1. So, if the date in A1 is 5/14/10, I need my formula to return the date 5/17/10.

Thanks for any help.
Jason

 

[wigi]

=a1+8-weekday(a1,2)

 

[JackDanIce]

Have a read of this link, I think you'll find a solution through this:
http://www.cpearson.com/excel/datetimews.htm

 

[Jon von der Heyden]

Try;
=CEILING(A1-2,7)+2

 

[barry houdini]

What if the original date is a Monday, should the formula return that date or the date 7 days later? Wigi's solution will do the latter, this does the former

=A1+7-WEEKDAY(A1-2)

 

[Jon von der Heyden]

Mine will also return the same date