I have a date field called Start Date. I am using column validation to allow users to select only 4 date values, if they enter other than this they see a validation error. So based on this Start Date Column, I have created a Calculated field called "Holiday Approval Credit", now the logic for this calculated field is like: If a user enters any of the above 4 dates, then they should see 0.5 as value in the Calculated field. So maybe something like this: =IF(Start Date="10/8/2018",0.5, IF(Start Date="9/3/2018",0.5)... Value would be 0 for dates other than these 4 dates. Can someone please help me with the correct formula, thanks in advance.
=(INT((WEEKDAY([Start Date]-1)+[End Date]-[Start Date])/7)*0.5)+(INT((WEEKDAY([Start Date]-7)+[End Date]-[Start Date])/7)*0.5)