Hi All!

I am trying to provide stats on data for my work - We have entries which sometimes fall on a weekend but these entries need to be reported as a weekday. From my knowledge the WEEKDAY function will report the following weekday from the weekend day. What I need is for a function to report the previous Friday.

Example:

If the entry falls on Saturday 27th October it needs to report as Friday 26th October. The same would apply for all Sundays.

If you could help I would be very grateful as this one is drying me a tiny bit mental :D Thanks in advance!