show first weekday

P

Peo Sjoblom

What do you want it to show when the current day is a Monday, next Monday
or current date?

If the former

=TODAY()-WEEKDAY(TODAY(),2)+8


if the latter


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

David Biddulph

=TODAY()+6-MOD(WEEKDAY(TODAY())+4,7)
Note that if today is Monday, it shows today's date.

If you want it to show next Monday if today is Monday, then try
=TODAY()+7-MOD(WEEKDAY(TODAY())+5,7)
 
D

David Biddulph

Yes, I thought my formulae looked more complicated than they needed to be.
:-(
 
D

Daniel.M

Hi,

Fails if today is a Sunday.
Any formula with 9 as an offset will fail for one precise day during the
week.

Regards,

Daniel M.
 
P

Peo Sjoblom

That won't show upcoming Monday, it will show the Monday of the current
week. For instance upcoming Monday for me for today (05/22/07) would be
05/28/07 but your formula returns 05/21/07. It might be that the OP wanted
this but the word upcoming makes me think it is not the case
 
Top