| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date calcuations
Im trying to develop a table to calculate annual salary remaining. With a 1
year date range based on 26.088 weeks in this range, what I would like to happen is to be able to enter any date in a cell and in another cell show the how much of the annual salary remains from the day entered. Example: assuming date range is Jan1,07 to Dec31,07 A1 €“ June 1, 2007(dd/mm/yyyy) B1 - $30,000 (annual salary) C1 =A2/26.088 (1149.95) €“Biweekly D1 (=???formula???) (Result- $14999.94) remains as of June 1,***rough calcualtions -- hard at work |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| Cell Calcuations | Excel Discussion (Misc queries) | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Threaded Mode
