leanete Wrote:
Can anyone help? I need to create a formula that will give me the
amount of days between two dates i.e., 01/31/05 - 01/01/05 = 30 days.
I know it's 30 because I used a sample that would be easy but I'm
working on a large amount that might be 60, 40 or so. I used the HELP
on Excel but it gives me i.e. 01/31/05 - 01/01/05 = 01/30/1900. What
am I doing wrong???
Please email me at
REALLY NEED HELP...!
Hi Leanete
Try formatting the cell where the result is as a number or as general
Paul
--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile:
http://www.excelforum.com/member.php...o&userid=24783
View this thread:
http://www.excelforum.com/showthread...hreadid=396168