I need to create a calculation that basically is a subtraction between two fields (2 date fields). However it should be done only if a 3rd field is equal to a value of 5 or 6.
- My first field is director approval date
- My second field is finance approval date
- My third field is either 5,6,7 or 8
I know this can be done in Excel but in my case I need this to be done in a calculated column in a SharePoint list.