Excel issue using datedif function
<p>I have a homework assignment that is to calculate the number of days between dates. It is a simple problem; however the format of the dates in column D are causing issue because of the date function. I am using DATEDIF but I am getting a name error. D is formatted as such =DATE(16,1,6), the E is =TODAY() and the datedif is =DATEDIF(D8,E3,D). Please help. =E3-D8 returns the serial 36548.</p>