{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["educba.com","DATE Example 1","DATE Example 2","DATE Example 3","VBA Examle with DATE Function"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"educba.com","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["DATE Function Excel Template"]
[]
["Visit:","www.educba.com"]
[]
["Email:","info@educba.com"]

{"sheet":"DATE Example 1","index":1,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Day","Month","Year","Full Date"]
[2,1,2018]
[5,6,2018]
[12,6,2018]
[14,10,2018]
[30,4,2018]
[1,5,2018]
[30,11,2018,null,null,null,43434]
[16,4,2018]
[12,8,2018]
[5,4,2018]
[10,3,2018]
[1,8,2018]
[31,2,2018]
[29,10,2018]
[16,9,2018]
[1,9,2018]
[31,7,2018]
[26,4,2018]
[18,11,2018]

{"sheet":"DATE Example 2","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Emp ID","Joining  Date","Relieving  Date","Total Tenure"]
["XC104","2012-01-28",{"$f":"B2+356","v":"2013-01-18"},{"$f":"DATEDIF(B2,C2,\"Y\")&\" Year \"&DATEDIF(B2,C2,\"YM\")&\" Months \"&DATEDIF(B2,C2,\"MD\")&\" Days\"","v":"0 Year 11 Months 21 Days"}]
["XD105","2012-11-02",{"$f":"B3+735","v":"2014-11-07"},{"$f":"DATEDIF(B3,C3,\"Y\")&\" Year \"&DATEDIF(B3,C3,\"YM\")&\" Months \"&DATEDIF(B3,C3,\"MD\")&\" Days\"","v":"2 Year 0 Months 5 Days"}]
["XC106","2012-07-18",{"$f":"B4+398","v":"2013-08-20"},"1 Year 1 Months 2 Days"]
["XD107","2013-02-22",{"$f":"B5+608","v":"2014-10-23"},"1 Year 8 Months 1 Days"]
["XC108","2012-12-03",{"$f":"B6+324","v":"2013-10-23"},"0 Year 10 Months 20 Days"]
["XC109","2013-05-18",{"$f":"B7+924","v":"2015-11-28"},"2 Year 6 Months 10 Days"]
["XD110","2013-01-24",{"$f":"B8+1924","v":"2018-05-02"},"5 Year 3 Months 8 Days"]
["XC100","2012-07-02",{"$f":"B9+1944","v":"2017-10-28"},"5 Year 3 Months 26 Days"]

{"sheet":"DATE Example 3","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Code","Result"]
["dd mm yyyy","2012-01-28"]
["dd-mm-yyyy","2012-01-28"]
["dd-mmm-yyyy","2012-01-28"]
["dd-mmmm-yyyy","2012-01-28"]
["dd mmm yyyy","2012-01-28"]
["dd mmmm yyyy","2012-01-28"]
["ddd mmmm yyyy","2012-01-28"]
["dddd mmmm yyyy","2012-01-28"]
["d m y","2012-01-28"]

{"sheet":"VBA Examle with DATE Function","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Employee ID","Employee Name","Department","DOJ","DOB","Total Tenurity","Email ID","Email ID Cc"]
["IDE182","Uzma Kausar","HR","2012-07-01","2018-09-02",{"$f":"DATEDIF(Employees_Table[DOJ],TODAY(),\"Y\")&\" Years \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"YM\")&\" Months \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"MD\")&\" Days\"","v":"6 Years 4 Months 14 Days"},"ananya@ide-global.com","jeevan@ide-global.com"]
["IDE011","Manjunath P","Admin & Finance","2012-08-21","2018-09-02",{"$f":"DATEDIF(Employees_Table[DOJ],TODAY(),\"Y\")&\" Years \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"YM\")&\" Months \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"MD\")&\" Days\"","v":"6 Years 2 Months 25 Days"},"jeevan@ide-global.com","Uzma@ide-global.com"]
["IDE021","Dilawar Hussain","Delegate Sales","2013-04-07","2018-09-02",{"$f":"DATEDIF(Employees_Table[DOJ],TODAY(),\"Y\")&\" Years \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"YM\")&\" Months \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"MD\")&\" Days\"","v":"5 Years 7 Months 8 Days"},"jeevan.ay2@gmail.com","jeevan.ide@gmail.com"]
["IDE023","Treyorika Sarah Lywait","Delegate Sales","2013-04-07","2018-09-02",{"$f":"DATEDIF(Employees_Table[DOJ],TODAY(),\"Y\")&\" Years \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"YM\")&\" Months \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"MD\")&\" Days\"","v":"5 Years 7 Months 8 Days"},"jeevan.ide@gmail.com","jeevan.ay2@gmail.com"]
["IDE039","Dinesh Samal","Delegate Sales","2013-08-26","2018-09-02",{"$f":"DATEDIF(Employees_Table[DOJ],TODAY(),\"Y\")&\" Years \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"YM\")&\" Months \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"MD\")&\" Days\"","v":"5 Years 2 Months 20 Days"},"ananya@ide-global.com","jeevan@ide-global.com"]
["IDE041","Amritha Gowda Mitta","Vendor Sales","2013-08-26","2018-09-02",{"$f":"DATEDIF(Employees_Table[DOJ],TODAY(),\"Y\")&\" Years \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"YM\")&\" Months \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"MD\")&\" Days\"","v":"5 Years 2 Months 20 Days"},"jeevan.ide@gmail.com","jeevan.ay2@gmail.com"]
["IDE042","Natasha C","Delegate Sales","2013-08-26","2018-09-02",{"$f":"DATEDIF(Employees_Table[DOJ],TODAY(),\"Y\")&\" Years \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"YM\")&\" Months \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"MD\")&\" Days\"","v":"5 Years 2 Months 20 Days"},"jeevan.ay2@gmail.com","jeevan.ide@gmail.com"]
["IDE062","Tensie Philomena","CRM","2014-03-17","2018-09-02",{"$f":"DATEDIF(Employees_Table[DOJ],TODAY(),\"Y\")&\" Years \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"YM\")&\" Months \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"MD\")&\" Days\"","v":"4 Years 7 Months 29 Days"},"jeevan.ide@gmail.com","jeevan.ay2@gmail.com"]
["IDE070","Srilakshmi","Production","2014-05-05","2018-09-02",{"$f":"DATEDIF(Employees_Table[DOJ],TODAY(),\"Y\")&\" Years \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"YM\")&\" Months \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"MD\")&\" Days\"","v":"4 Years 6 Months 10 Days"},"jeevan.ay2@gmail.com","jeevan.ide@gmail.com"]
["IDE100","Jeevan A Y","MIS & Finance","2014-10-13","2018-09-02",{"$f":"DATEDIF(Employees_Table[DOJ],TODAY(),\"Y\")&\" Years \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"YM\")&\" Months \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"MD\")&\" Days\"","v":"4 Years 1 Months 2 Days"},"jeevan.ide@gmail.com","jeevan.ay2@gmail.com"]
["IDE117","Kartik Kashyap","Vendor Sales","2015-01-27","2018-09-02",{"$f":"DATEDIF(Employees_Table[DOJ],TODAY(),\"Y\")&\" Years \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"YM\")&\" Months \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"MD\")&\" Days\"","v":"3 Years 9 Months 19 Days"},"jeevan.ide@gmail.com","jeevan@ide-global.com"]
["IDE119","Gayathri S","CRM","2015-02-02","2018-09-02",{"$f":"DATEDIF(Employees_Table[DOJ],TODAY(),\"Y\")&\" Years \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"YM\")&\" Months \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"MD\")&\" Days\"","v":"3 Years 9 Months 13 Days"},"jeevan@ide-global.com","jeevan.ay2@gmail.com"]
["IDE121","Priyanka M","CRM","2015-02-23","2018-09-02",{"$f":"DATEDIF(Employees_Table[DOJ],TODAY(),\"Y\")&\" Years \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"YM\")&\" Months \"&DATEDIF(Employees_Table[DOJ],TODAY(),\"MD\")&\" Days\"","v":"3 Years 8 Months 23 Days"},"jeevan.ide@gmail.com","jeevan.ay2@gmail.com"]