I have insurance policy expiry dates within a form and need to calculate the number of days until expiry date. I have tried various formulas but no results. I’m sure it’s simple but it eludes me. Screen shot attached. Any help would be appreciated.
Hi! This is Kate from Ragic Support team. So the insurance policy expiry date is stored in field D14 right? You can create a field and include the following formula:
TODAYTZ()-D14
Hope this helps!
HI Kate,
Many thanks, worked like a charm, I had tried this but did not realise the formula is case sensitive.