Date Function formula that will return the date of a specific week

I am trying to set up a date field in a spreadsheet that will always give the
date of the upcoming Saturday. I have tried the "Weekday" function along with
the "If" and the "If/Or" statements without success. Can someone help?

try
=TODAY()-WEEKDAY(TODAY())+7

--
Don Guillett
SalesAid Software
[email protected]
"Greg" <[email protected]> wrote in message
news:[email protected]...
>I am trying to set up a date field in a spreadsheet that will always give
>the
> date of the upcoming Saturday. I have tried the "Weekday" function along
> with
> the "If" and the "If/Or" statements without success. Can someone help?

Greg --

Here's something. Tried it and it seems to work. If today's date is in
cell A1:

=A1+(7-WEEKDAY(A1))

HTH

"Greg" wrote:

> I am trying to set up a date field in a spreadsheet that will always give the
> date of the upcoming Saturday. I have tried the "Weekday" function along with
> the "If" and the "If/Or" statements without success. Can someone help?

Hi

Try this:
=A2+(7-WEEKDAY(A2))
with your date in A2

Hope this helps.
Andy.

"Greg" <[email protected]> wrote in message
news:[email protected]...
>I am trying to set up a date field in a spreadsheet that will always give
>the
> date of the upcoming Saturday. I have tried the "Weekday" function along
> with
> the "If" and the "If/Or" statements without success. Can someone help?

try:

=TODAY()+7-WEEKDAY(TODAY())

"Greg" wrote:

> I am trying to set up a date field in a spreadsheet that will always give the
> date of the upcoming Saturday. I have tried the "Weekday" function along with
> the "If" and the "If/Or" statements without success. Can someone help?