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

[Greg]

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?

 

[Don Guillett]

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

 

[pdberger]

Greg --

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

=A1+(7-WEEKDAY(A1))

HTH

 

[Guest]

Hi

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

Hope this helps.
Andy.

 

[Toppers]

try:

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