If the dates are seen by Excel as dates (meaning numbers and not text) then
you just need to subtract
=B1-A1
where A1 has start date and B1 end date
format cell as general
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
"HELP FRANCES" <HELP
wrote in message
...
I need to figure out how to calculate from an original date obtained to the
next date obtained? How do I calculate this?