Hi Dave

in your particular scenario, where you are only concerned with
calculating the number of months of depreciation, you might be better to
use 28/01/06, 28/02/06, 28/03/06 etc. for your dates in your month
header row, and FormatCellsNumberCustom mmm to give Jan, Feb etc.

Then for your asset acquisition / creation date, always use 28/mm/yy
then the Datedif solution will work fine without the adjustments as
suggested by myself and others.

--
Regards

Roger Govier


"Dave F" wrote in message
...
So how do I get Excel to determine that 3/31/2006 and 4/30/2006 are,
in fact,
a month apart?

Dave
--
Brevity is the soul of wit.


" wrote:

Dave F wrote:
Here's the formula:
=IF(I$6<$G14,"",IF($F14<0,"N/A",IF(DATEDIF($G14,I$6,"m")/$B$3*$F14$F14,"",DATEDIF($G14,I$6,"m")/$B$3*$F14)))
I6 is 4/30/2006, G14 is 3/31/2006, F14 is $85,968, B3 is 48

I think it should resolve to 1/48*$85,968 = $1,791. But excel is
calculating it as $0.00.
Thoughts?

DATEDIF() is returns zero for those two dates. Apparently DATEDIF()
does not consider them to be a month apart.