Formula Subtracting dates to come up with number of days

K

Katherine

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
 
J

JE McGimpsey

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.
 
G

Guest

-----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
Click to expand...
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.
 
Top