I am currently trying to create a chart based off an excel spreadsheet where
dates need to be calculated. I need to know how to calculate the difference
between dates in days so that I can have that information in a graph.
--
Mike H.
Data Review Specialist

Dates in A1 and B1, difference in days =B1-A1.
--
David Biddulph

"Mike H." wrote in message
...
I am currently trying to create a chart based off an excel spreadsheet
where
dates need to be calculated. I need to know how to calculate the
difference
between dates in days so that I can have that information in a graph.
--
Mike H.
Data Review Specialist

You would just subtract one date value from another.

If cell A1 has 10/15/1979 and cell A2 has 3/11/2008 the formula would be:

=A2-A1

With 10375 being the number of elapsed days. You will most likely have to
format the cell with the function as a number as it will default to a date
format.

Check out Chip Pearson's website for more on date and time functions at the
following URL:

http://www.cpearson.com/excel/datearith.htm

--
Kevin Backmann


"Mike H." wrote:

I am currently trying to create a chart based off an excel spreadsheet where
dates need to be calculated. I need to know how to calculate the difference
between dates in days so that I can have that information in a graph.
--
Mike H.
Data Review Specialist