Chart Help

[Mike H.]

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.

 

[David Biddulph]

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

 

[Kevin B]

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