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.

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

"robzrob" wrote in message
...
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 Monday? Return today's date or next Monday's date?

--
Biff
Microsoft Excel MVP


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





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

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

Regards,
Bernd

On Aug 31, 10:12*pm, Bernd P wrote:
=CEILING(A1+6,7)-5
In A1 you have today's date or
=CEILING(TODAY()+6,7)-5

Regards,
Bernd

Thanks, Bernd

On Aug 31, 10:17*pm, robzrob wrote:
On Aug 31, 10:12*pm, Bernd P wrote:

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

Regards,
Bernd

Thanks, Bernd


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

Thanks, All

On Aug 31, 10:19*pm, robzrob wrote:
On Aug 31, 10:17*pm, robzrob wrote:

On Aug 31, 10:12*pm, Bernd P wrote:

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

Regards,
Bernd

Thanks, Bernd

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

Thanks, All


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

Hi Biff,

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

Regards,
Bernd