Date formula problems - Excel 2003

**martindwilson** · 04-14-2009, 08:50 AM

use date.diff
=DATE.DIFF(A1,A2,3) where a1 earliest date a2 latest date the 3 is to display in ymd
but i think its part of the more functions addin.!
there is the hidden function(well i cant see it in excel2003)
of DATEDIF (notice! no full stop )
see here
http://www.cpearson.com/excel/datedif.aspx
or
http://www.meadinkent.co.uk/xl_birthday.htm
for how to use it

**daddylonglegs** · 04-14-2009, 08:56 AM

d and m formats are really designed for calendar months so m is always at least 1 (and won't exceed 12 even if your dates are more than a year apart). You can use this formula to get months, days and hours/minutes

=DATEDIF(A2,B2-(MOD(B2,1)<MOD(A2,1)),"m")&" months "&DATEDIF(A2,B2-(MOD(B2,1)<MOD(A2,1)),"md")&" days "&TEXT(B2-A2,"hh:mm")

assuming start time/date in A2 and end time/date in B2

**lembi2001** · 04-14-2009, 11:46 AM

works a treat. thanks.

Sorry to be a pest but how can i get the average time from this now? i have a number of fields containing this date difference but i need to get the average, max and min from them.

Thanks