I have a problem that hopefully someone can assist in solving.
I need to calculate tem number of days between two dates - no problems there but....
I an effort to "automate" the process I wish to draw in the start and end dates from a table into which these dates have been saved.
A sample of part of the worksheet is:
Cell B9 - School Year : 2015 (This is entered by the user)
Cell B10 - Term : 1 (This is entered by the user
Cell B11 - Enter Term Start Date : 29-January-2015 This data I need to import from the data table that exists in cells e17:h105 but related to the correct year from the value in B9 in column E AND the correct associated value from
B10 in column F and the corresponding value for THAT result from column G
Cell B12 - Enter Term End Date : 12-April-2015 This data I need to import from the data table that exists in cells e17:e105 but related to the correct year from the value in B9 in column E AND the correct associated value from
B10 in column F and the corresponding value for THAT result from column H
Cell B13 - Elapsed Week Days (less Holidays) = 54 The formula I have here works correctly of I manually enter the start and end dates - =NETWORKDAYS($B$11,$B$12,$A$17:$A$302)
but I want to eliminate the manual date entry and have the dates drawn in from the data table automatically based on the year and term dates I manually enter in cells b9 and B10
Column A Column E:G
Holidays School Terms
01-Jan-15 New Years Day Year Term Term Begins Term Ends Weeks Rows 17:300 (including heading row)
26-Jan-15 Australia Day 2015 1 28-Jan-15 03-Apr-15 9 Rows 17:
03-Apr-15 Good Friday 2015 2 21-Apr-15 26-Jun-15 9.5
04-Apr-15 Easter Saturday 2015 3 14-Jul-15 18-Sep-15 9.5
05-Apr-15 Easter Sunday 2015 4 06-Oct-15 16-Dec-15 10
Can anyone assist is advising how to perform this function?
Thanks in advance.
Bookmarks