Calculate next Monday (date) based on NOW

[Hendrik]

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

 

[T. Valko]

Try this:

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

 

[Hendrik]

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.

 

[David Biddulph]

Are you sure, Hendrik? Which version of Excel? It seems to work OK for me
in Excel 2003.
What number (in General format) is NOW() returning? What does
=WEEKDAY(A1,3) return?
[I could get your wrong answer by using WEEKDAY(A1,2) instead of
WEEKDAY(A1,3) but I hope you copied and pasted T Valko's formula rather than
retyping it and risking errors.]

 

[T. Valko]

Hmmm....

Well, it works for me as:

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

Retrns 1/28/2008

 

[Hendrik]

Hi,

I made a mistake. Sorry guys, works perfect!

 

[T. Valko]

Glad you got it straightened out. Thanks for letting us know.