Determine next Saturday based on a given date

[Ann]

If I have a date in a cell, I need to determine the date of the following
Saturday. For example, if I have the date of 10/8/2006 in a cell, I need the
function to return the date 10/14/2006.

 

[Niek Otten]

=A1+7-WEEKDAY(A1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| If I have a date in a cell, I need to determine the date of the following
| Saturday. For example, if I have the date of 10/8/2006 in a cell, I need the
| function to return the date 10/14/2006.

 

[Niek Otten]

Or, if A1 can be a Saturday as well,

=A1+IF(WEEKDAY(A1)=7,14,7)-WEEKDAY(A1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| If I have a date in a cell, I need to determine the date of the following
| Saturday. For example, if I have the date of 10/8/2006 in a cell, I need the
| function to return the date 10/14/2006.

 

[daddylonglegs]

Hi Niek, you can simplify that to

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

 

[Niek Otten]

Yes, indeed!

Thanks,

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi Niek, you can simplify that to
|
| =A1+7-WEEKDAY(A1+2,3)
|
| "Niek Otten" wrote:
|
| > Or, if A1 can be a Saturday as well,
| >
| > =A1+IF(WEEKDAY(A1)=7,14,7)-WEEKDAY(A1)
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | If I have a date in a cell, I need to determine the date of the following
| > | Saturday. For example, if I have the date of 10/8/2006 in a cell, I need the
| > | function to return the date 10/14/2006.
| >
| >
| >

 

[Ron Rosenfeld]

If I have a date in a cell, I need to determine the date of the following
Saturday. For example, if I have the date of 10/8/2006 in a cell, I need the
function to return the date 10/14/2006.

It depends on what you want to do if the date is a Saturday.

If you want the next Saturday, then:

=A1-WEEKDAY(A1+1)+8

Saturday, October 07, 2006 Saturday, October 14, 2006
Sunday, October 08, 2006 Saturday, October 14, 2006
Monday, October 09, 2006 Saturday, October 14, 2006
Tuesday, October 10, 2006 Saturday, October 14, 2006
Wednesday, October 11, 2006 Saturday, October 14, 2006
Thursday, October 12, 2006 Saturday, October 14, 2006
Friday, October 13, 2006 Saturday, October 14, 2006



If you want it to not change, then:

=A1-WEEKDAY(A1)+7

Saturday, October 07, 2006 Saturday, October 07, 2006
Sunday, October 08, 2006 Saturday, October 14, 2006
Monday, October 09, 2006 Saturday, October 14, 2006
Tuesday, October 10, 2006 Saturday, October 14, 2006
Wednesday, October 11, 2006 Saturday, October 14, 2006
Thursday, October 12, 2006 Saturday, October 14, 2006
Friday, October 13, 2006 Saturday, October 14, 2006



--ron