Calculate Week end date from a date

[markster]

Hello,

In Column H I have dates e.g. 8-Nov-21 I need a formula for column I that calculates the week ending date which will always be a Friday. So in this case 8-Nov-21 is a Monday so the week ending date to be populated in column I is 12-Nov-21. If the date in column H was 17-Nov-21 week ending date to be populated in column I would be 19-Nov-21. All dates contained in Column H will be a Monday to Friday date. Can anyone help? Thanks

 

[Fluff]

How about

+Fluff 1.xlsm
	H	I
1
2	08/11/2021	12/11/2021
3	12/11/2021	12/11/2021
4	17/11/2021	19/11/2021
Main

Cell Formulas
Range	Formula
I2:I4	I2	=WORKDAY.INTL(H2-1,1,"1111011")

 

[Joe4]

Try this, for an entry in cell H1:

=H1+7-WEEKDAY(H1,16)

​

​

 

[markster]

Thanks very much guys!

 

[Fluff]

Glad we could help & thanks for the feedback.