Determine next Saturday based on a given date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=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.
 
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.
 
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.
| >
| >
| >
 
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.
Click to expand...

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
 
Back
Top