| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
date calcuations
Why not divide by 365 to get the salary per day? Then you need only to multiply
by the number of days left in the year, as in: =(date(year(a1),12,31)+1-a1)*b1/365 -- Regards, Fred "Carlene" wrote in message ... I'm 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
date calcuations
The key is 26.088 used in salary calculations universally at work It may
have something to do with using the fiscal year instead of the calendar year. I believe using "days" calculation slightly alters the outcome. -- hard at work "Fred Smith" wrote: Why not divide by 365 to get the salary per day? Then you need only to multiply by the number of days left in the year, as in: =(date(year(a1),12,31)+1-a1)*b1/365 -- Regards, Fred "Carlene" wrote in message ... I'm 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
date calcuations
They're accounting for leap years in that the average number of days in a
year is 365.25. 365.25 / 14 (days in a pay period) = 26.08929 Biff "Carlene" wrote in message ... The key is 26.088 used in salary calculations universally at work It may have something to do with using the fiscal year instead of the calendar year. I believe using "days" calculation slightly alters the outcome. -- hard at work "Fred Smith" wrote: Why not divide by 365 to get the salary per day? Then you need only to multiply by the number of days left in the year, as in: =(date(year(a1),12,31)+1-a1)*b1/365 -- Regards, Fred "Carlene" wrote in message ... I'm 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
date calcuations
Regardless, you're still going to have to calculate a daily rate. So use C1/7
instead of A1/365. -- Regards, Fred "Fred Smith" wrote in message ... Why not divide by 365 to get the salary per day? Then you need only to multiply by the number of days left in the year, as in: =(date(year(a1),12,31)+1-a1)*b1/365 -- Regards, Fred "Carlene" wrote in message ... I'm 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 |
| Reply |
| 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 | |||
Hybrid Mode
