B
bshuemaker
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.
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.