Change Weekend Date To The Previous Friday

[MarkMcCann]

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!

[Fotis1991]

Try

=IF(WEEKDAY(A1)=7,A1-1,IF(WEEKDAY(A1)=1,A1-2,A1))

[benishiryo]

hi MarkMcCann, welcome to the forum. maybe something like:
=IF(WEEKDAY(A1,2)>=6,A1+5-WEEKDAY(A1,2),A1)

[daddylonglegs]

You could use WORKDAY function like this

=WORKDAY(A1+1,-1)