Result is fixed weekday

[Pepestru]

Hi there, I have a little problem with calculating a date.
I have a cell (e.g. A1) with a date. Another cell (e.g. B1) has a number (number of days).
In cell C1 I want a new date = A1+B1. That's easy!
My question: when the date in C1 is not a Friday, the result must be the first Friday after the date (A1+B1).
A friend tells me that this can only be solved with a macro, but before trying that I wonder if someone
has a better solution with only a formula?
Thanks,
Paul

 

[etaf]

how about
=(A1+B1) + (6 - WEEKDAY(A1+B1))

Book1
	A	B	C	D	E
1	1/1/23	10		Next Friday	1/13/23
2
3	a1+b1	1/11/23
4
5	Day	Wednesday			Friday
Sheet1

Cell Formulas
Range	Formula
E1	E1	=(A1+B1) + (6 - WEEKDAY(A1+B1))
B3	B3	=A1+B1
B5	B5	=B3
E5	E5	=E1

 

[Phuoc]

Try this:

=WORKDAY.INTL(A1+B1-1,1,"1111011")

 

[Phuoc]

Or try this:

Book1
	A	B	C
1	1/1/2023	10	1/13/2023
Sheet1

Cell Formulas
Range	Formula
C1	C1	=CEILING(A1+B1,7)-1

 

[Pepestru]

Thanks. I prefer the first solution. Simply because I can use it right away. Nevertheless I will also study the other 2 options , to get familiar to more excel functons.
Paul