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!
Bookmarks