Default to a particular day of week

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

Guest

I would like to default to a Friday when a date is entered in a cell. For
example:

Cell A2 = 4/2/07
Cell A3 should default to 4/6/07

So for any date from Saturday to Friday would default to the Friday.

Thanks in advance.
 

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

Shift Schedule Formula 1
If C2 is Sunday how do I make D 2 to the next day of the week 2
formula 1
Date plus month, year, or years in workdays 5
Formula for adding a day to a particular date. 1
5 working days of a week 4
Formula to display next Friday from B1 works except on the Friday itself. 4
Find specific date for day in week 4

Back
Top