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.