Date Round Up
 

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.

Date Round Up
 

Sorry, mistake in the below, columns should read:

Column A Column B
01/01/07 05/01/07
02/01/07 05/01/07
03/01/07 05/01/07
04/01/07 05/01/07
05/01/07 05/01/07
06/01/07 12/01/07

"shakey1181" wrote:

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.

Date Round Up
 

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.

Date Round Up
 

I've assumed the next Friday as in your example and not saturday as in the text


=A1+IF(WEEKDAY(A1)=7,13-WEEKDAY(A1),6-WEEKDAY(A1))

In B1 and drag down

Mike

"shakey1181" wrote:

Sorry, mistake in the below, columns should read:

Column A Column B
01/01/07 05/01/07
02/01/07 05/01/07
03/01/07 05/01/07
04/01/07 05/01/07
05/01/07 05/01/07
06/01/07 12/01/07

"shakey1181" wrote:

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.

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.