show first weekday
 

How can I always display the upcoming Monday date?

show first weekday
 

try
=TODAY()+(9-WEEKDAY(TODAY()))

--
Don Guillett
SalesAid Software

"MPI Planner" <MPI wrote in message
...
How can I always display the upcoming Monday date?

show first weekday
 

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



--
Regards,

Peo Sjoblom


"MPI Planner" <MPI wrote in message
...
How can I always display the upcoming Monday date?

show first weekday
 

=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)
--
David Biddulph

"MPI Planner" <MPI wrote in message
...
How can I always display the upcoming Monday date?

show first weekday
 

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

"Peo Sjoblom" wrote in message
...
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

--
Regards,

Peo Sjoblom


"MPI Planner" <MPI wrote in message
...
How can I always display the upcoming Monday date?

show first weekday
 

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.

"Don Guillett" wrote in message
...
try
=TODAY()+(9-WEEKDAY(TODAY()))

--
Don Guillett
SalesAid Software

"MPI Planner" <MPI wrote in message
...
How can I always display the upcoming Monday date?

show first weekday
 

Try:

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

Kind regards,
Erny

"MPI Planner" <MPI schrieb im Newsbeitrag
...
How can I always display the upcoming Monday date?

show first weekday
 

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


--
Regards,

Peo Sjoblom



"Erny" wrote in message
...
Try:

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

Kind regards,
Erny

"MPI Planner" <MPI schrieb im
Newsbeitrag ...
How can I always display the upcoming Monday date?