-
(5 * ( FLOOR( ( Leave_Start_Date__c - DATE( 1900, 1, 8) ) / 7 ) ) + MIN( 5, MOD( Leave_Start_Date__c - DATE( 1900, 1, 8), 7 ) ) )
- IF(
AND(First_Day_Half_Day__c = True, Last_Day_Half_Day__c = True),
1,
IF(
OR(First_Day_Half_Day__c = True, Last_Day_Half_Day__c = True),
0.5,0)
)
-
IF(
AND(
Leave_Start_Date__c <= DATE(2015,12,25),
DATE(2015,12,25) <= Leave_Finish_Date__c
), 1, 0
)
-
IF(
AND(
Leave_Start_Date__c <= DATE(2015,12,28),
DATE(2015,12,28) <= Leave_Finish_Date__c
), 1, 0
)
-
IF(
AND(
Leave_Start_Date__c <= DATE(2016,01,01),
DATE(2016,01,01) <= Leave_Finish_Date__c ,BU__c = 'Galway'
), 1, 0
)
-
IF(
AND(
Leave_Start_Date__c <= DATE(2015,10,26),
DATE(2015,10,26) <= Leave_Finish_Date__c ,BU__c = 'Galway'
), 1, 0
)
-
IF(
AND(
Leave_Start_Date__c <= DATE(2015,04,06),
DATE(2015,04,06) <= Leave_Finish_Date__c
), 1, 0
)
-
IF(
AND(
Leave_Start_Date__c <= DATE(2015,03,17),
DATE(2015,03,17) <= Leave_Finish_Date__c ,BU__c = 'Galway'
), 1, 0
)
-
IF(
AND(
Leave_Start_Date__c <= DATE(2015,05,04),
DATE(2015,05,04) <= Leave_Finish_Date__c
), 1, 0
)
-
IF(
AND(
Leave_Start_Date__c <= DATE(2015,06,01),
DATE(2015,06,01) <= Leave_Finish_Date__c
), 1, 0
)
-
IF(
AND(
Leave_Start_Date__c <= DATE(2015,08,03),
DATE(2015,08,03) <= Leave_Finish_Date__c ,BU__c = 'Galway'
), 1, 0
)
-
IF(
AND(
Leave_Start_Date__c <= DATE(2015,08,31),
DATE(2015,08,31) <= Leave_Finish_Date__c ,BU__c = 'UK'
), 1, 0
)
-
IF(
AND(
Leave_Start_Date__c <= DATE(2015,05,25),
DATE(2015,05,25) <= Leave_Finish_Date__c ,BU__c = 'UK'
), 1, 0
)
-
IF(
AND(
Leave_Start_Date__c <= DATE(2015,04,03),
DATE(2015,04,03) <= Leave_Finish_Date__c ,BU__c = 'UK'
), 1, 0
)
Its wont compile as it is two long
답변 4개
Hi Olivia,
Its all about trial and error just extend the field update formula and see what happens.
