#### Formula Subtracting dates to come up with number of days

```HELP - does anyone have a formula that I can use to put a
date in a colume to subtract it from a date in another
column for the purpose of determining the number of days
between the two dates?  Thank you
``` 0 8/16/2004 1:42:14 PM excel.misc  78881 articles. 5 followers. 3 Replies 342 Views Similar Articles

[PageSpeed] 3

```Hi

--
Regards
Frank Kabel
Frankfurt, Germany

Katherine wrote:
> HELP - does anyone have a formula that I can use to put a
> date in a colume to subtract it from a date in another
> column for the purpose of determining the number of days
> between the two dates?  Thank you
``` 0 8/16/2004 1:51:15 PM
```XL stores dates as integer offsets from a base date, so if your dates
are in A1 and B1 then

C1:     =B1 - A1

Format C1 as General or another number format.

In article <6e8101c48396\$d68c52b0\$a401280a@phx.gbl>,
"Katherine" <funny_face01@hotmail.com> wrote:

> HELP - does anyone have a formula that I can use to put a
> date in a colume to subtract it from a date in another
> column for the purpose of determining the number of days
> between the two dates?  Thank you
``` 0 8/16/2004 1:53:58 PM
```>-----Original Message-----
>HELP - does anyone have a formula that I can use to put a
>date in a colume to subtract it from a date in another
>column for the purpose of determining the number of days
>between the two dates?  Thank you
>.
>Excel will automatically use the number of days when
subtracting one cell from another.  go the the cell w/
your dates, click on format / cells / number tab /
general, then make sure you see a number.  This should be
the number of days since 01/01/01.
``` 0 8/16/2004 3:42:28 PM Similar Artilces: