{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Contents","Introduction WEEKDAY","Weekday","Weekday with Choose","WEEK Start on Monday"],"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":[]}
["WEEKDAY Function"]
[null,"automateexcel.com/functions/weekday-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction WEEKDAY",null,null,null,"Excel Formulas w/Examples"]
[null,"Weekday",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Weekday with Choose",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"WEEK Start on Monday"]
[]
[]
[]
[]
[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 WEEKDAY","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"WEEKDAY",null,"=WEEKDAY (serial_number, [return_type])"]
[]
[null,"The Excel WEEKDAY function takes a date and returns a number between 1-7 "]
[null,"representing the day of week"]
[]
[null,"Date","Day","Return Type","Result"]
[null,"2020-01-05",{"$f":"TEXT(B8,\"DDD\")","v":"Sun"},1,{"$f":"WEEKDAY(B8,D8)","v":1}]
[null,"2020-01-05",{"$f":"TEXT(B9,\"DDD\")","v":"Sun"},2,{"$f":"WEEKDAY(B9,D9)","v":7}]
[null,"2020-01-05","Sun",3,6]
[]
[null,"automateexcel.com/functions/weekday-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Weekday","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Day","Return Type","Result"]
[null,"2020-01-05",{"$f":"TEXT(B3,\"DDD\")","v":"Sun"},1,{"$f":"WEEKDAY(B3,D3)","v":1}]
[null,"2020-01-05",{"$f":"TEXT(B4,\"DDD\")","v":"Sun"},2,{"$f":"WEEKDAY(B4,D4)","v":7}]
[null,"2020-01-06",{"$f":"TEXT(B5,\"DDD\")","v":"Mon"},1,{"$f":"WEEKDAY(B5,D5)","v":2}]
[null,"2020-01-06","Mon",2,1]
[]
[null,"automateexcel.com/functions/weekday-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Weekday with Choose","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Result"]
[null,"2020-01-05",{"$f":"CHOOSE(WEEKDAY(B3),\"Sun\",\"Mon\",\"Tue\",\"Wed\",\"Thu\",\"Fri\",\"Sat\")","v":"Sun"}]
[]
[null,"automateexcel.com/functions/weekday-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"WEEK Start on Monday","index":4,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Day","Result"]
[null,"2020-01-06",{"$f":"TEXT(B3,\"DDD\")","v":"Mon"},{"$f":"WEEKDAY(B3,2)","v":1}]
[]
[null,"automateexcel.com/functions/weekday-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]