How to Calculate Days Difference between Two Dates

PrevContributor
PrevContributor
in Modeling

Does anyone know how to calculate the difference of days between two days? For example, (4/1/2015) - (4/5/2015) = 4 Thanks!

Tagged:

Best Answer

  • PrevContributor
    PrevContributor
    Answer ✓
    If you have two fields that are date fields. You can create a third field as a number and put in a formula just to subtract the one date from the other

    Example

    Date 1: 3/9/2016
    Date 2: 3/11-2016
    Difference: 'date 2' - 'date 1'

    This would give you the result of 2

Categories