Date Difference

[Hiteshp]

How do i get the count between 2 dates. I have the following data available:

Start Date	End Date
1/7/2025	1/7/2025
2/11/2025	2/11/2025
3/10/2025	3/11/2025

  Need the output in the following order:

Start Date	End Date	Count
1/7/2025	1/7/2025	1
2/11/2025	2/11/2025	1
3/10/2025	3/11/2025	2

[CoG · Accepted solution]

DateTimeDiff([End Date], [Start Date], "Day") + 1

[Qiu · Accepted solution]

@Hiteshp 
Just add to CoG advice, we need 2 DateTime tools to convert the Date in String to DateTime format