| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with dates & calculations
I receive payments from different people every month... every month, there
are additions to the list as also people who drop out from the system.... I want to calculate monthwise what my income is...e.g Start Date---Payment----Termination Date Apr'08 May'08 Jun'08 12-Apr-08 5000 =(5000/30)*19 5000 5000 1-Apr-08 10000 15-May-08 10000 5000 ----- 5-Apr-08 5000 25-Apr-08 =(5000/30)*21 ---- ---- 1-Jun-08 4000 ------ ---- 4000 can some one help....the forumla becomes quite complex....and am not getting the hang, where i am going wrong Nikhil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculations using dates -- HELP! | Excel Discussion (Misc queries) | |||
| Removing Weekend dates from Day Calculations | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Difference in dates calculations except between certain times. | Excel Discussion (Misc queries) | |||
| auto-calculations using calendar and dates (Excel-Office 2000) | Excel Worksheet Functions | |||
Threaded Mode
