C
Carlene
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
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