| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Use a calc to figure sum in months using date fields but numeric r
When doing a pricing structure, I need to use a date to calculate and then
round into a whole number or decimal , for ex; from 1/1/5 - 6/15/5 how many months = 6.5 The return is then used to calculate costs involved with different scenarios for sales and clients. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a date 6 months from a date in another cell | Excel Worksheet Functions | |||
| Autofilter on date fields should refelct the underlying data (rat. | Excel Discussion (Misc queries) | |||
| Formula to calucate # of months based on a speificed date entered | Excel Worksheet Functions | |||
| calc constant date from variable date & return with ability to rn. | Excel Worksheet Functions | |||
| Comparing Date Fields | Excel Worksheet Functions | |||
Threaded Mode
