I'm trying to create a formula wherein an annual salary for an employee is allocated monthly starting on hire date until the nearest pay period (We are using semi monthly). It should show monthly amounts in the monthly columns until the employee is terminated and calculation should stop then. (ex. A is employed on 1/21/11 with 90k salary. The formula should compute it monthly until the employee is terminated lets say on 6/31/11)
I've been doing this the whole day but i am lost as i am not yet accustomed to the different formulas in excel.
Please help..
Thanks,
Bookmarks