Counting days in between two dates

I am having trouble calculating a "days past due" between two dates

For example, 11/01/23 and 11/05/23 - I am wanting to calculate the days in between those two in a new column

Thank you in advance!

Workflow

Accepted answers

@maddoxs you need to convert the dates into ISO format

Date_291123.yxmd

All comments

DateTimeDiff([Date Received],[Document Date],'Days')

Would a formula like this work?

@maddoxs you need to convert the dates into ISO format

Date_291123.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15875

MarqueeCrew 13708

apathetichell 13703