Days between dates in Excel

Article View: comp.sys.mac.apps

Article #8363

#8363

From: Robert Owen
Date: Fri, 12 Apr 1991 20:57

20 lines
1279 bytes

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  |
===========================================================================

Technical Details

Message-ID: <26540001@hpldsla.sid.hp.com>

Path:

arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!sdd.hp.com!hplabs!hpl-opus!hpcc05!hpldsla!rowen

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!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