LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto fill columns based on a selection ckane Excel Discussion (Misc queries) 1 May 4th 07 05:34 AM
Auto fill Column based on data in other columns SITCFanTN New Users to Excel 1 June 6th 06 09:04 PM
I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns. Marc Excel Worksheet Functions 0 May 22nd 06 08:41 PM
Auto fill of columns linstock Excel Discussion (Misc queries) 1 January 3rd 06 11:23 PM
Auto Protecting cells & auto filling date ccarmock Excel Discussion (Misc queries) 7 September 30th 05 09:21 PM


All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"