How about
:
=DATE((2000+INT(K2/1000)),0,MOD(K2,1000))
- DATE((2000+INT(J2/1000)),0,MOD(J2,1000))
+ 1
(all one cell.)
Just a tip.
It's better to give a small sample of your data in your initial post. It makes
things easier for possible responders.
saltrm wrote:
I got a value of "34391" when I applied the formula. Maybe I did
something wrong when applying?
=ABS(DATE(INT(J2)/1000+IF(J2<30000,2000,1900),1,MOD(J2,1000))
-DATE(INT(K2)/1000+IF(K2<30000,2000,1900),1,MOD(K2,1000)))
That the what I used
MY spreadsheet looks like this
J-2 K-2 L-2
4350 5310 Should read "325"
--
saltrm
------------------------------------------------------------------------
saltrm's Profile: http://www.excelforum.com/member.php...o&userid=28624
View this thread: http://www.excelforum.com/showthread...hreadid=482869
--
Dave Peterson