Monday Following

  • Thread starter Thread starter robzrob
  • Start date Start date
R

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.
 
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
 
=CEILING(A1+6,7)-5
In A1 you have today's date or
=CEILING(TODAY()+6,7)-5

Regards,
Bernd
 
Hi Biff,

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

Regards,
Bernd
 
Back
Top