View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 299
Default ND TO CALC FROM ORIG DATE TO NEXT DATE RECEIVED?

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?