formula

[Craig]

I'm tring to write a formula using two dates that will
return the number of days that have passed?

 

[Frank Kabel]

Hi
just subtract them.
e.g.
=B1-A1
and format the target cell as 'Number'

 

[Darlene Silveira]

Hello,
Here's an example, I hope this helps.

If cell A1, has the date 3/26/2002,
If cell A3, has the date 8/10/2004,

In cell A5, you would enter this formula to get the number
of days that have passed:

=(A3-A1)

This will give you 5/17/1902

Then change this cell format to a general number
and it will then display 868 which is the amount of days
that have passed between the two dates.

If you wanted to find out the number of years that have
passed, you would divide that number by 365.