G Guest Jun 28, 2007 #1 I need to figure out how to calculate from an original date obtained to the next date obtained? How do I calculate this?
I need to figure out how to calculate from an original date obtained to the next date obtained? How do I calculate this?
P Peo Sjoblom Jun 28, 2007 #2 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)
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)
