calculating intervals

  • Thread starter Thread starter lulu
  • Start date Start date
L

lulu

What type of formula could I use to calculate the amount
of days within a time interval? There is no variable
here. For example, I wanted to count the days between the
date in cell 1 (10/1/03) and cell 2 (11/15/03). Please
help. Thank you.
 
Dates in XL are just integer offsets from a base date, so you can
just subtract:

A1: 10/1/03
A2: 11/15/03
A3: =A2 - A1

You'll probably have to reformat A3 as General or another number
format. XL's parser for some reason thinks that subtracting dates is
likely to return a date.
 
Back
Top