Hello all you Excel wizards. I would like some help. I want to find out if there is a formula that can be used to return the date of the Friday of the week ending based on a cell in which a date has been entered.eg In cell A1, a date has been entered, such as 13/01/2015. I want cell B1 to show the date corresponding to the week ending date (the Friday) based on the date in cell A1. In this example, B1 needs to return the date 16/01/2015, being the week ending (Friday) date corresponding to 13/01/2015. Then, whenever cell A1 is amended, B2 should automatically change as appropriate. Can anyone help?