Works great thanks.

I did have to change the 7 to 8 though, not sure why. NOW=25-01-08 and
result is 27-01 with +7, 28-01 with +8.

But this will do fine.

"T. Valko" wrote:

Try this:

=INT(A1)-WEEKDAY(A1,3)+7

--
Biff
Microsoft Excel MVP


"Hendrik" wrote in message
...
Hi,

Say I have a formula in A1: "=NOW()"

In another cell I want to calculate the next Monday, but I can't figure
this
one out. Thanks for any suggestions..

Hendrik