{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Contents","Introduction WORKDAY","Nearest Workday","Nearest Workday to Today","Nearest WORKDAY in 10 Days","Nearest WORKDAY 10 Before ","Workday with Holidays"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["WORKDAY Function"]
[null,"automateexcel.com/functions/workday-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction WORKDAY",null,null,null,"Excel Formulas w/Examples"]
[null,"Nearest Workday",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Nearest Workday to Today",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Nearest WORKDAY in 10 Days"]
[null,"Nearest WORKDAY 10 Before "]
[null,"Workday with Holidays"]
[]
[]
[null,"Excel Boot Camp"]
[null,"  Learn Excel Inside Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Introduction WORKDAY","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"WORKDAY",null,"=WORKDAY (start_date, days, [holidays])"]
[]
[null,"The Excel WORKDAY function takes a date and returns the nearest working day "]
[null,"in the future or past, based on an offset value you provide"]
[]
[null,"Start Date","Days","Result",null,"HOLIDAYS"]
[null,"2020-01-01",10,{"$f":"WORKDAY(B8,C8,F8:F9)","v":"2020-01-16"},null,"2020-01-01"]
[null,"2020-01-01",30,{"$f":"WORKDAY(B9,C9,F8:F9)","v":"2020-02-13"},null,"2020-01-10"]
[null,"2020-01-01",-30,{"$f":"WORKDAY(B10,C10,F8:F9)","v":"2019-11-20"}]
[]
[null,"automateexcel.com/functions/workday-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Nearest Workday","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","Days","Result"]
[null,"2020-04-10",0,{"$f":"WORKDAY(B3,C3)","v":"2020-04-10"}]
[null,"2020-04-10",1,{"$f":"WORKDAY(B4,C4)","v":"2020-04-13"}]
[null,"2020-04-10",-1,"2020-04-09"]
[]
[null,"automateexcel.com/functions/workday-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Nearest Workday to Today","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Days","Result"]
[null,0,{"$f":"WORKDAY(TODAY(),B3)","v":"2021-08-31"}]
[null,1,{"$f":"WORKDAY(TODAY(),B4)","v":"2021-09-01"}]
[null,-1,"2021-08-30"]
[]
[null,"automateexcel.com/functions/workday-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Nearest WORKDAY in 10 Days","index":4,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","Days","Result"]
[null,"2020-01-01",10,{"$f":"WORKDAY(B3,C3)","v":"2020-01-15"}]
[]
[null,"automateexcel.com/functions/workday-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Nearest WORKDAY 10 Before ","index":5,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","Days","Result"]
[null,"2020-01-01",-10,{"$f":"WORKDAY(B3,C3)","v":"2019-12-18"}]
[]
[null,"automateexcel.com/functions/workday-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Workday with Holidays","index":6,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","Days","Result",null,"HOLIDAYS"]
[null,"2020-01-01",10,{"$f":"WORKDAY(B3,C3,F3:F4)","v":"2020-01-16"},null,"2020-01-01"]
[null,null,null,null,null,"2020-01-10"]
[]
[null,"automateexcel.com/functions/workday-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]