View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bshuemaker bshuemaker is offline
external usenet poster
 
Posts: 2
Default Protecting and Auto fill Columns

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.