Forum Discussion
Number of days + or -
I am trying to get the difference in the number of days between two dates and it works if the target completion date is before the completion date using this formula: =DATEDIF(H3,J3,"d"). I do get th...
With Excel's default date settings (the "1900 date system"), Excel dates are internally represented as the number of days since (approximately) 1 Jan 1900. So you can simply subtract one date from another to get the difference (positive, negative, or zero).
