why isn't this formula calculating correctly?
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.
|