Help

Date Difference Issues

Topic Labels: Dates & Timezones
Solved
Jump to Solution
968 1
cancel
Showing results for 
Search instead for 
Did you mean: 
C_Paulson
4 - Data Explorer
4 - Data Explorer

Hello–I have a simple question that I am struggling to solve. I am trying to calculate the difference between two dates but I need it to count full days. For example in the first record Start date of 1/2 and end date of 1/3 needs to equal 2 and not 1. The same with the 3 record–I need a formula that will calculate this to be 5 and not 4.

Thanks in advance.

Screen Shot 2020-06-18 at 5.35.02 PM Screen Shot 2020-06-18 at 5.35.06 PM

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Just add a +1 to the end of your formula! :slightly_smiling_face:

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

See Solution in Thread

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

Just add a +1 to the end of your formula! :slightly_smiling_face:

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face: