Help

Counting Days between two Date Fields

Topic Labels: Formulas
4162 6
cancel
Showing results for 
Search instead for 
Did you mean: 
George_Zaloom
4 - Data Explorer
4 - Data Explorer

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

6 Replies 6
George_Zaloom
4 - Data Explorer
4 - Data Explorer

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

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

DATETIME_DIFF(End, Start, 'days')

Screenshot 2019-09-19 at 08.37.46.png

JB

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

WORKDAY_DIFF(Start, End)

Screenshot 2019-09-19 at 08.40.03.png

George_Zaloom
4 - Data Explorer
4 - Data Explorer

this is sooooo helpful!
Thanks a mil!

Anat_Moroshek
4 - Data Explorer
4 - Data Explorer

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

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