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

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

Guest

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
 
Hi

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

Hope this helps.
Andy.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re: How can I count the number of SATURDAYS in a month? 0
Workday Formula to include date 0
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
if statements returning dates 4
Function to Return a Date Value Q 4
Testing a cell value for a specific weekday. 3
how to count my paydays before the due-date of a bill? 11
Sumif weekday 3

Back
Top