Formula to adjust a weekend date to the previous Friday...

1. Formula to adjust a weekend date to the previous Friday...

I have the following formula: =IF(E54="PCS",H54-183,H54-249)

This will give me a specific date. Sometimes this date falls on a Saturday, Sunday or Holiday. Is there a way to build the formula to check if the date is a Saturday, Sunday or Holiday and automatically adjust to the nearest previous Friday?

TIA!!!
Crystal

2. Re: Formula to adjust a weekend date to the previous Friday...

Try

=IF(E54="PCS",WORKDAY(WORKDAY(H54-183,1),-1),WORKDAY(WORKDAY(H54-249,1),-1))

3. Re: Formula to adjust a weekend date to the previous Friday...

Worked great! Thank you!

4. Re: Formula to adjust a weekend date to the previous Friday...

This version should also work.....

=WORKDAY(H54-IF(E54="PCS",183,249)+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