Count Days

  • Thread starter Thread starter Michelle Adams
  • Start date Start date
M

Michelle Adams

This is my problem - hopefully someone can HELP!!

I am trying to calculate # of days between two different
columns.

Example - In column A I have date "12/15/2003" in Column
B I have "03/04/2004" - and I want the # of days to go in
column C. Then I need that exact formula (w/ different
dates) to do the same exact thing all the down the spread
sheet. PLEASE - anyone who can help!!!
 
Michelle

just subtract the two cells and format as general. You need to decide
whether one or both dates are included so you might need to add 1 to the
result. For example

B1 - A1 + 1

Regards

Trevor
 
Dates in excel are just integers that are offset from a base date
(12/31/1899 for the Windows default 1900 date system, 1/1/1900 for the
Mac default 1904 date system). So you can just do normal math on them:

A1: 12/15/2003
B1: 03/04/2004
C1: =B1 - A1 => 80

You'll have to format C1 as General - why XL thinks subtracting two
dates should result in a date, I'll never know...

You can then copy C1 down as far as required.
 
Back
Top