Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Payroll Forecast Calc
Hi all. I need to write a formula to calculate monthly payroll, based
on a hire date and termination date. The spreadsheet is sut up with the Months going across the top of the sheet (AA3:AL3), with the format being 1/1/2008, 2/1/2008, etc. Essentially, there are 5 areas within the IF statement: Hire date is lest than current month (no pay) Hire date is within current month, and must be prorated Hire date is after current month, and before termination date (full pay) Current month is after Termination date (no pay) Seems like this is a pretty standard type of payroll calc. I'm hoping that somene already has this massive formula written! Anyone? Thanks so much!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calc = Manual & Do Not Calc b/4 SAVE | Excel Discussion (Misc queries) | |||
My calc key on Excel changes box to "Text" Box and doesn't calc ? | Charts and Charting in Excel | |||
Adding payroll stubs payroll calculator | New Users to Excel | |||
auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
forecast | Excel Discussion (Misc queries) |