Week Ending Date based off cell with formula

[pup33pawz]

Hello!

I am trying to formulate a week ending date based off of a cell that contains a formula. For example: C1 contains =IF(B1 = "Sara",TODAY(),""). This returns today's date. I would like D1 to calculate the week ending date based off of the date generated on C1. Is this possible? I've tried =(7-WEEKDAY(C1,11))+C1 but that returns #Value error

 

[pup33pawz]

Works like a charm

My final formula was =IF(C1<>"",(7-WEEKDAY(C1,2))+C1,"")

Thank you for help!