On Apr 25, 12:41 pm, bshuemaker
wrote:
Hello everyone,

I am trying to create a spreadsheet that will track the dates of a new hire
that has certain things to be complete. For example:
The new hire reported on 4/25/2008
The new hire will be on probation for 6 months (10/25/2008) (need data to
auto fill into the spreadsheet).
The new hire will be certified 12 months later on date (4/25/2009) need data
to auto fil into the spreadsheet)

Here is the formula that i came up with,
report date Column F
=SUM(F2:F214+180) (6 months probation) Column G (auto fill from column f
with new date)
=SUM(F2:F214+365) (12 months to get certified) Colum H (auto fill from
column f with new date)

If this sounds confusing, please let me know, and I can email you a copy of
my spreadsheet. Thank you for your help.

So, what exactly are you asking? I'm not sure how a SUM helps you.

This is probably a better way if you are just trying to find dates,
since 180 days is not necessarily 6 months:
=EDATE(A2,6)
That gives you the date 6 months from the date in A2.