| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ND TO CALC FROM ORIG DATE TO NEXT DATE RECEIVED?
I need to figure out how to calculate from an original date obtained to the
next date obtained? How do I calculate this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #VALUE in Date calc | Excel Worksheet Functions | |||
| Calc End Date | Excel Worksheet Functions | |||
| calculate the number of days from date received | Excel Worksheet Functions | |||
| Date Calc. HELP | New Users to Excel | |||
| calc constant date from variable date & return with ability to rn. | Excel Worksheet Functions | |||
Linear Mode
