Monday Following

[robzrob]

Hello

I'm sure I've done this before, but I can't remember how. I need a
cell to return the date of the first Monday after today.

 

[David Biddulph]

=TODAY()+7-WEEKDAY(TODAY(),3)

 

[T. Valko]

What if today is Monday? Return today's date or next Monday's date?

 

[Peo Sjoblom]

What if today is a Monday, next Monday or current?

If you always want the next Monday

=TODAY()+CHOOSE(WEEKDAY(TODAY()),1,7,6,5,4,3,2)


unless today is a Monday

=TODAY()-WEEKDAY(TODAY()-2)+7



--


Regards,


Peo Sjoblom

 

[Bernd P]

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

Regards,
Bernd

 

[robzrob]

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

Regards,
Bernd

Thanks, Bernd

 

[robzrob]

Thanks, Bernd

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

Thanks, All

 

[robzrob]

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

Thanks, All

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

 

[Bernd P]

Hi Biff,

If a Monday should result in same day, don't add 6 but 5:
=CEILING(A1+5,7)-5

Regards,
Bernd