Change Weekend Date To The Previous Friday

1. Change Weekend Date To The Previous Friday

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!

2. Re: Change Weekend Date To The Previous Friday

Try

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

3. Re: Change Weekend Date To The Previous Friday

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

4. Re: Change Weekend Date To The Previous Friday

You could use WORKDAY function like this

=WORKDAY(A1+1,-1)

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1