show first weekday

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
=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)
 
Yes, I thought my formulae looked more complicated than they needed to be.
:-(
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WEEKDAY 7
How to format cell to get first capital letter? 5
calculating only weekdays 6
Show dates based on criteria 3
Hi i want to buy a pc but i am not sure if it s good and future proof 0
Display yesterday's date but only for weekdays? 7
Date Function formula that will return the date of a specific week 4
Excel Table Help 2

Back
Top