{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Contents","Introduction Date","DATE","DATE-DM-ZERO","DATE-DM-Negative","First Day of the Year"],"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":[]}
["DATE Function"]
[null,"automateexcel.com/functions/date-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction Date",null,null,null,"Excel Formulas w/Examples"]
[null,"DATE",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"DATE-DM-ZERO",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"DATE-DM-Negative"]
[null,"First Day of the Year"]
[]
[]
[]
[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 Date","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DATE","=DATE (year, month, day)"]
[]
[null,"The DATE function creates a valid date from individual year, month, and day components."]
[]
[]
[null,"Year","Month","Day","Result"]
[null,2020,1,15,{"$f":"DATE(B8,C8,D8)","v":"2020-01-15"}]
[null,2020,0,0,{"$f":"DATE(B9,C9,D9)","v":"2019-11-30"}]
[null,2020,40,40,{"$f":"DATE(B10,C10,D10)","v":"2023-05-10"}]
[null,2020,-10,-10,"2019-01-21"]
[]
[null,"automateexcel.com/functions/date-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"DATE","index":2,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Year","Month","Day","Result"]
[null,2020,1,15,{"$f":"DATE(B3,C3,D3)","v":"2020-01-15"}]
[]
[null,"automateexcel.com/functions/date-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"DATE-DM-ZERO","index":3,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Year","Month","Day","Result"]
[null,2020,0,0,{"$f":"DATE(B3,C3,D3)","v":"2019-11-30"}]
[]
[null,"automateexcel.com/functions/date-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"DATE-DM-Negative","index":4,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Year","Month","Day","Result"]
[null,2020,-5,-5,{"$f":"DATE(B3,C3,D3)","v":"2019-06-25"}]
[]
[null,"automateexcel.com/functions/date-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"First Day of the Year","index":5,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Result"]
[null,"2020-10-15",{"$f":"DATE(YEAR(B3),1,1)","v":"2020-01-01"}]
[]
[null,"automateexcel.com/functions/date-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]