{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Contents","Introduction DAY","Day","Year to date","Day Date"],"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":[]}
["DAY Function"]
[null,"automateexcel.com/functions/day-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction DAY",null,null,null,"Excel Formulas w/Examples"]
[null,"Day",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Year to date",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Day Date"]
[]
[]
[]
[]
[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 DAY","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DAY","=DAY (Serial_number)"]
[]
[null,"The Excel DAY function returns the day of the month as a number between "]
[null,"1 to 31 from a given date."]
[]
[null,"Date","Result"]
[null,"2020-01-01",{"$f":"DAY(B8)","v":1}]
[null,"2020-05-31",{"$f":"DAY(B9)","v":31}]
[null,"2019-03-10",10]
[]
[null,"automateexcel.com/functions/day-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Day","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Result"]
[null,"2020-01-01",{"$f":"DAY(B3)","v":1}]
[null,"2020-05-31",{"$f":"DAY(B4)","v":31}]
[null,"2019-03-10",10]
[]
[null,"automateexcel.com/functions/day-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Year to date","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Result"]
[null,"2020-01-01",{"$f":"B3-DATE(YEAR(B3),1,1)+1","v":1}]
[null,"2020-05-20",{"$f":"B4-DATE(YEAR(B4),1,1)+1","v":141}]
[null,"2020-12-31",366]
[]
[null,"automateexcel.com/functions/day-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Day Date","index":4,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Result"]
[null,"2020-01-15",{"$f":"DATE(2021,1,DAY(B3))","v":"2021-01-15"}]
[]
[null,"automateexcel.com/functions/day-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]