Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto fill columns based on a selection | Excel Discussion (Misc queries) | |||
Auto fill Column based on data in other columns | New Users to Excel | |||
I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns. | Excel Worksheet Functions | |||
Auto fill of columns | Excel Discussion (Misc queries) | |||
Auto Protecting cells & auto filling date | Excel Discussion (Misc queries) |