Calculate next Monday (date) based on NOW

H

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
 
H

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.
 
D

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.]
 
Top