tammyl
11-11-2014, 06:32 PM
Hi,
Hoping someone can assist. i know that i can test if a workday = 6 (Friday) and then do a if (a1)=6,workday(a1)-1,(a1)
To calculate the date (a1) i already have a big formula to take into consideration matching dates and text in a table & holdiays.
I used workday.intl to tell workdays are only Monday to Thursday "0000111".
This worked well except is pushes the Friday to the following Monday.
I need the workday.intl to push the Friday to the earlier Thursday, that is -1...only if the day falls on a Friday.
Can workday.intl do this or do i need to use the full if, then, else formula.
I was trying to keep my formula as simple & short as possible so others could maintain updates.
Any help much appreciated.
Tammy
Hoping someone can assist. i know that i can test if a workday = 6 (Friday) and then do a if (a1)=6,workday(a1)-1,(a1)
To calculate the date (a1) i already have a big formula to take into consideration matching dates and text in a table & holdiays.
I used workday.intl to tell workdays are only Monday to Thursday "0000111".
This worked well except is pushes the Friday to the following Monday.
I need the workday.intl to push the Friday to the earlier Thursday, that is -1...only if the day falls on a Friday.
Can workday.intl do this or do i need to use the full if, then, else formula.
I was trying to keep my formula as simple & short as possible so others could maintain updates.
Any help much appreciated.
Tammy