Counting Days between two Date Fields

[George_Zaloom]

is there a formula to count the number of days between two date fields?

[George_Zaloom]

I want to show how many days from start to finish.

[JonathanBowen]

Hi @George_Zaloom - you can do this with the DATETIME_DIFF() function:

DATETIME_DIFF(End, Start, 'days')

JB

[JonathanBowen]

Or, if you only want to count weekdays/working days:

WORKDAY_DIFF(Start, End)

[George_Zaloom]

this is sooooo helpful!
Thanks a mil!

[Anat_Moroshek]

Hi, How I can use DATETIME_DIFF() function, the IDE doesn’t recognizes it

[Anat_Moroshek]

Hi, How I can use DATETIME_DIFF() function, the IDE doesn’t recognizes it