Calculate Week-end date for each date listed

[neelymedlock]

What would be the formula to calculate the week-end date (sunday) for each date listed.

Ex

Date Week-end Date
Tues 5/15/18 Sun 5/20/18
Fri 5/18/18 Sun 5/20/18
Wed 5/23/18 Sun 5/27/18

 

[jproffer]

Maybe this:

Excel 2013/2016
	A	B
1	6/15/2018	6/17/2018
2	6/16/2018	6/17/2018
3	6/17/2018	6/17/2018
4	6/18/2018	6/24/2018
5	6/19/2018	6/24/2018
6	6/20/2018	6/24/2018
7	6/21/2018	6/24/2018
8	6/22/2018	6/24/2018
9	6/23/2018	6/24/2018
10	6/24/2018	6/24/2018
11	6/25/2018	7/1/2018
12	6/26/2018	7/1/2018
13	6/27/2018	7/1/2018
14	6/28/2018	7/1/2018
15	6/29/2018	7/1/2018
16	6/30/2018	7/1/2018
17	7/1/2018	7/1/2018
18	7/2/2018	7/8/2018
19	7/3/2018	7/8/2018
20	7/4/2018	7/8/2018
Sheet3

Cell Formulas
Range	Formula
B1	=A1+(7-WEEKDAY(A1,2))

Does that give the results you're expecting?

 

[neelymedlock]

Its giving me an error

 

[neelymedlock]

Yes, that worked, now. Thank you!

 

[jproffer]

You're quite welcome. Glad it worked and thanks for the feedback