Date Round Up
perfect, thankyou so much.
"Ernst Schuurman" wrote:
use in B1 the formula =A1+7-WEEKDAY(A1)
best wishes
Ernst Schuurman
"shakey1181" schreef in bericht
...
All,
Trying to round up a date to the nearest Saturday and am struggling to get
the correct result. Can't find a solution using the ROUND or ROUNDUP
formula.
Column A Column B
01/01/07 05/01/07
02/01/07 06/01/07
Thanks in advance for any help.
|