2 Q's. How to add X months to a date &

G

Guest

Q. 1: 2/12/04 + 6 months ? Result wanted is 8/12/04
Q. 2: Looking for a matrix to calculate proposed hourly rate increases over
pre-set time periods while looking to see if a junior employee would exceed a
veteran employee's hourly wage over time.

Example - A 6 year employee was hired at current starting wage at that time.
New employees will be hired under a proposed increase starting pay (to
remain competitive in the market) All employees receive a predetermined
increase every 6 months. Now after a couple years, junior employees will
exceed veteran employees hourly wage. A readjustment is needed. Need a
matrix with formulas with an argument linked to another cell which would be
used to test increase results.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add 2 months and a variable number of days to a date 3
Need to average a range AND calc a formula at once... 1
Need to select record based on date 5
Modifying a complex date formual to count months 4
Desperately trying to build a paid time off accrual worksheet... 9
Converting a date range to number of months or weeks 3
How to do a formula counting the number of hours between 2 times? 2
Formula to Compute Overtime hours 1

Top