I want to calculate the number of weeks that a record will be early or late based on three variables. The Delivery Date, The Ex Factory Date and the Freight method.
The formula below is the equivalent of what i would use in excel. I calculate it in days and then divide by 7 to show the number of weeks. The formula doesn’t seem to work in Airtable and i cant work out why this is. I was wondering if anyone would be able to give me some advice on this?