Tutorial :datedif in excel when the number format is [$-409]d-mmm-yyyy;@



Question:

I have two columns with the format [$-409]d-mmm-yyyy;@, I want to calculate the difference of date of these two columns. Please help.

Thanks


Solution:1

The =datedif() formula will do that for you, as per http://www.cpearson.com/excel/datedif.aspx:

=datedif(FirstDate, LaterDate, Interval)

Where FirstDate is the earlier date, LaterDate is the later date, and interval is the return type. I usually use 'm' for months, since this can be divided by 12 to get decimal years. Lots of other options, though.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »