Hire date monthly impact formula in excel

March 14, 2011 at 20:10:03
Specs: Windows XP
Hi, I'm trying to come up with a formula that will calculate the impact of hiring for certain positions in Q2 based on the date of hire. For instance if I hire a new resource on May 1at at an annual salary of $50,000, what formula, based on that hire date, can i use in the columns for April, May, and June to reflect the impact ($0 in April, $4,167 in May, $4,167 in June)?

See More: Hire date monthly impact formula in excel

Report •

March 14, 2011 at 20:12:54
I should have clarified: the goal is to be able to run different scenarios by changing the hire dates for potential resources....thx!

Report •

March 15, 2011 at 21:56:17
Thia post should be here for better help: http://www.computing.net/forum/offi...

Report •
Related Solutions

Ask Question