Subtraction will give you the difference in days (those are the units that dates are stored in). In that case, you can use the integer function to chop off times before subtraction ( =INT(B1)-INT(A1)).ĭATEDIF also adds a feature over a simple subtraction: you can specify the units you want, and it can do some convenient conversion functions. Even without rounding, the result can still include a fraction of a day, which can give you inaccurate results in calculations if the calculations are based on whole day counts. If your values are date/times, simply subtracting the values will give a result that includes a time difference, which could round to another day and give you the wrong result. A pure date is stored as a date as of crossing midnight (time of 0).
Dates and times are stored together (dates are day counts, stored as the integer portion of the value times are fraction of a day, stored with the day count as a decimal fraction). You can do a simple date subtraction, but there are a few things to be aware of.ĭATEDIF ensures that you're working with dates rather than date/times.
Cybernetic.nomad is correct in that Microsoft says it's supposed to be there.
0 kommentar(er)
