Hi All,how would I amend the formula below to include Working Days of Monday to Friday and working hours of 9am to 5:15 pm in the out put? INT(DATETIME_DIFF(NOW(), {Credit decision date}, 'hours')/24)&" Days "&MOD(DATETIME_DIFF(NOW(), {Credit decisio...
Hi All,How would I extract only the end of unique URLs on airtable. complete URL https://lucyshops.shopping.com/#opportunities/12345ad-2gh7-115a-07f569f605dpart I want to extract 12345ad-2gh7-115a-07f569f605dif this helps the formula required is simi...
the ones high lighted yellow to return as blanksHi All,I've been trying to use the below formula to exclude weekends, so rather than showing 7 days to show 5 days instead. it seem to make sense using 3 but I'm not sure why? when the formula is return...
thank you, This formula makes the count down change from 5 days remaining to 1 day remaining. I want it to count down from {Date Reservation Time Stamp}) each day that passes the counter would drop a day until it reaches 0
