Formula Subtracting dates to come up with number of days

  • Thread starter Thread starter Katherine
  • Start date Start date
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
 
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.
 
-----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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
Trailing 30 days sum calculation with excel 1
Excel formulas + subtraction of days 2
Subtracting number of days excluding the weekend 2
Subtracting Dates 4
If Tuesday subtract 4 (Formulas) 3
Subtracting Holidays from Calendar Days 4
Subtracting Dates 2

Back
Top