Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!sdd.hp.com!hplabs!hpl-opus!hpcc05!hpldsla!rowen From: rowen@hpldsla.sid.hp.com (Robert Owen) Newsgroups: comp.sys.mac.apps Subject: Days between dates in Excel Message-ID: <26540001@hpldsla.sid.hp.com> Date: 12 Apr 91 20:57:02 GMT Organization: HP Scientific Instruments Division - Palo Alto, CA Lines: 20 To describe my problem I'll post the problem: I want to have two cells contain a date in Excel's date format (m/d/yy) and in the third cell have a formula that calculates days between dates. Like this: 4/12/91 4/13/91 1 I was able to perform the date calculation, but unable to have the formula grab the date from another cell without getting an error. I do have the manual and still I am stymied! =========================================================================== | Bob Owen | /\ | Bob Owen /hp2300/60 | | Scientific | /\ \_____________/\_________| rowen@sid.hp.com | | Instruments | /\ \_________/\____________ | Phone (415) 857-7425 | | Division |/ \____/\________________ | FAX (415) 852-8011 | ===========================================================================