Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 Q's. How to add X months to a date &
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 Q's. How to add X months to a date &
With the 2/12/04 in A1
=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Charlie7805" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Calculate 1st of month date from existing date. | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
How to Highlight the date if it is within 3 months from now | Excel Worksheet Functions | |||
Use a calc to figure sum in months using date fields but numeric r | Excel Worksheet Functions |