{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","VBA_Weekday","VBA_WeekdayName","VBA_WeekendDate","VBA_WeekDayDisplay"],"not_rendered":{"charts":0,"images":0,"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":"Dataset","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Employee Name","Joining Date"]
[null,"Robert",{"$f":"TODAY()","v":"2022-01-10"}]
[null,"Allen","2021-08-01"]
[null,"Miller","2021-07-30"]
[null,"Emma ","2021-07-25"]
[null,"Sarah","2021-06-01"]
[null,"Linda","2021-06-13"]
[null,"Laura","2021-07-02"]
[null,"Harris",{"$f":"TODAY()","v":"2022-01-10"}]

{"sheet":"VBA_Weekday","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Finding the Day of Week Using the Weekday Function"]
[]
[null,"Employee Name","Joining Date","Day of Week"]
[null,"Robert",{"$f":"TODAY()","v":"2022-01-10"},2]
[null,"Allen","2021-08-01",1]
[null,"Miller","2021-07-30",6]
[null,"Emma ","2021-07-25",1]
[null,"Sarah","2021-06-01",3]
[null,"Linda","2021-06-13",1]
[null,"Laura","2021-07-02",6]
[null,"Harris",{"$f":"TODAY()","v":"2022-01-10"},2]

{"sheet":"VBA_WeekdayName","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Obtaining the Day of Week Using the WeekdayName Function"]
[]
[null,"Employee Name","Joining Date","Day of Week","Name of the Day of Week"]
[null,"Robert",{"$f":"TODAY()","v":"2022-01-10"},2,"Tue"]
[null,"Allen","2021-08-01",1,"Mon"]
[null,"Miller","2021-07-30",6,"Sat"]
[null,"Emma ","2021-07-25",1,"Mon"]
[null,"Sarah","2021-06-01",3,"Wed"]
[null,"Linda","2021-06-13",1,"Mon"]
[null,"Laura","2021-07-02",6,"Sat"]
[null,"Harris",{"$f":"TODAY()","v":"2022-01-10"},2,"Tue"]

{"sheet":"VBA_WeekendDate","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Getting the Next Weekend Date Using VBA Weekday Function"]
[]
[null,"Joining Date","Next Weekend Date?"]
[null,{"$f":"TODAY()","v":"2022-01-10"},"2022-01-15"]
[null,"2021-08-01","This is actually the weekend Date"]
[null,"2021-07-30","2021-07-31"]
[null,"2021-07-25","This is actually the weekend Date"]
[null,"2021-06-01","2021-06-05"]
[null,"2021-06-13","This is actually the weekend Date"]
[null,"2021-07-02","2021-07-03"]
[null,{"$f":"TODAY()","v":"2022-01-10"},"2022-01-15"]

{"sheet":"VBA_WeekDayDisplay","index":4,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Displaying The Day of Week Using VBA MsgBox"]
[]
[null,"Employee Name","Joining Date"]
[null,"Robert",{"$f":"TODAY()","v":"2022-01-10"}]
[null,"Allen","2021-08-01"]
[null,"Miller","2021-07-30"]
[null,"Emma ","2021-07-25"]
[null,"Sarah","2021-06-01"]
[null,"Linda","2021-06-13"]
[null,"Laura","2021-07-02"]
[null,"Harris",{"$f":"TODAY()","v":"2022-01-10"}]