Date Formula to always return with next Friday Date?
Hi  Any idea if you are able to add in formulas in the date field to always have the result for the next Friday? For example, if I have a date of Thursday, 3/21; I would like the formula to reflect the next Friday date, so the cell would reflect 3/29. The dates would change but it would have a formuIa in there that would calculate the next Friday's date. Is that a possibility? I know you can do it in Excel, but can I do that in SS? Thank you in advance for your help!!
Best Answer

What if the date is a Friday date? Would you want 1 week in the future or two weeks in the future?
Answers

What if the date is a Friday date? Would you want 1 week in the future or two weeks in the future?

Paul Newcome  the date would have to be a Friday date. Whether if it is 1 or 2 weeks in the future, it depends on the first date in the cell. For example, 3/21 the Friday date would be 3/29. However, if the date was 3/25 it would still be 3/29. Hope that answers your question. Thank you.

I meant the starting date. What if your starting date is on a Friday. So 3/22 for instance?

Paul Newcome  if the starting date is Friday, it would be the next Friday as the returned date. Thank you again for looking into this!

Ok. So that leaves me with just one more question...
You say "...3/21 the Friday date would be 3/29. However, if the date was 3/25 it would still be 3/29..."
Why would the Thursday date go to the following week's Friday, but the Monday date goes to the same week's Friday?

Paul  We have an important mtg on Wed so that is why the 3/21 would go to 3/29 because the Wed mtg needs to occur. If it is 3/25, we have the Wed mtg on 3/27 so then the date would be 3/29. Thank you again!

Ok. So Saturday through Wednesday go to the very next Friday, Thursday goes to the second Friday out, and Friday just goes out one week?
Saturday = +6 days
Sunday = +5 days
Monday = +4 days
Tuesday = +3 days
Wednesday = +2 days
Thursday = +8 days
Friday = +7 days

Hi Jen,
You may want to use the WEEKDAY function in a nested IF as below:
WEEKDAY(currentdate) Returns a number representing the day of the week, 1–7, where Sunday equals 1
=IF(WEEKDAY(currentdate)=1, currentdate@row + 5, IF(WEEKDAY(currentdate)=7, currentdate@row + 6, IF(WEEKDAY(currentdate)=6, currentdate@row + 7, IF(WEEKDAY(currentdate)=5, currentdate@row + 8, IF(WEEKDAY(currentdate)=4, currentdate@row + 9, IF(WEEKDAY(currentdate)=3, currentdate@row + 10, IF(WEEKDAY(currentdate)=2, currentdate@row + 11)))))))
Hope this works for you.
Gia Thinh Technology Co., LTD  Smartsheet Solution Partner.

@Gia Thinh That formula will not output what the poster desires. It can also be made more efficient by using
=(Date@row + (6  WEEKDAY(Date@row))) + IF(WEEKDAY(Date@row) >= 6, 7, 0)
There will just need to be a minor tweak to the above based on the response to when we move to the next week.
@Jen C Rethinking the logic, I feel like the easiest way to explain what you are looking for (correct me if I am wrong) is actually the Friday after the next Wednesday. So basically you want to look for the next Wednesday so that you can have your Wednesday meeting and then add 2 days to get the end of whatever week the next Wednesday is in? If so, give this a try:
=(Date@row + (4  WEEKDAY(Date@row))) + IF(WEEKDAY(Date@row) >= 4, 7, 0) + 2