On Aug 31, 10:19*pm, robzrob wrote:
On Aug 31, 10:17*pm, robzrob wrote:

On Aug 31, 10:12*pm, Bernd P wrote:

=CEILING(A1+6,7)-5
In A1 you have today's date or
=CEILING(TODAY()+6,7)-5

Regards,
Bernd

Thanks, Bernd

Always the first Monday after today, even if today is a Monday.

Thanks, All


You're bloody marvellous, all of you!!!!