{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":84,"n_cols":7,"rows_kept":84,"merged":[[33,3,33,4],[49,10,49,13],[80,3,80,6]]}
["Find the difference in years:",null,null,"Start date","End date","Result"]
[{"$nulls":3},"2014-01-14","2016-05-06",{"$f":"DATEDIF(D2,E2,\"y\")","v":2}]
[]
["Find the difference in months:",null,null,"Start date","End date","Result"]
[{"$nulls":3},"2014-01-01","2016-05-06",{"$f":"DATEDIF(D5,E5,\"m\")","v":28}]
[]
[]
["Find the difference in days:",null,null,"Start date","End date","Result"]
[{"$nulls":3},"2014-01-01","2016-05-06",{"$f":"DATEDIF(D9,E9,\"d\")","v":856}]
[]
[]
["Find the difference in weeks:",null,null,"Start date","End date","Result"]
[{"$nulls":3},"2014-01-01","2016-05-06",{"$f":"DATEDIF(D13,E13,\"d\")/7","v":{"v":122.28571428571429,"d":"122.29"}}]
[]
["Calculate age in accumulated"]
["years, months and days:",null,null,"Start date","End date","Result","Unit of time"]
[{"$nulls":3},"2014-01-01","2016-05-06",{"$f":"DATEDIF(D17,E17,\"y\")","v":2},"years"]
[{"$nulls":5},{"$f":"DATEDIF(D17,E17,\"ym\")","v":4},"months"]
[{"$nulls":5},{"$f":"E17-DATE(YEAR(E17),MONTH(E17),1)","v":5},"days"]
[{"$nulls":4},"All in one:",{"$f":"DATEDIF(D17,E17,\"y\")&\" years, \"\n&DATEDIF(D17,E17,\"ym\")&\" months, \"\n&E17-DATE(YEAR(E17),MONTH(E17),1)&\" days\"","v":"2 years, 4 months, 5 days"}]
[]
[{"$nulls":3},"Tip: Press ALT+ENTER to put line breaks in your formula."]
[{"$nulls":3},"Also, press CTRL+SHIFT+U if you can’t see the whole formula."]
[]
[]
["Calculate the difference between"]
["today and another date:",null,null,"End date",null,"Result"]
[{"$nulls":3},"3000-12-31",null,{"$f":"DATEDIF(TODAY(),D28,\"y\")","v":984}]
[]
["Calculate workdays, with"]
["or without holidays:",null,null,"First, make a list of all holidays in a separate area. "]
[{"$nulls":3},"Make sure each date is in its own cell."]
[]
[{"$nulls":3},"Holidays"]
[{"$nulls":3},"2016-01-01","2016-09-05"]
[{"$nulls":3},"2016-01-18","2016-10-10"]
[{"$nulls":3},"2016-02-15","2016-11-11"]
[{"$nulls":3},"2016-05-30","2016-11-24"]
[{"$nulls":3},"2016-07-04","2016-12-25"]
[" "]
[]
[{"$nulls":3},"After you put each holiday in its own cell,"]
[{"$nulls":3},"select those cells. Then go to Formulas > Define Name."]
[{"$nulls":3},"Name the range, and click OK."]
[]
[{"$nulls":3},"Note: We have done this already in this workbook."]
[{"$nulls":3},"We named the range, \"MyHolidays.\" You can see "]
[{"$nulls":3},"the name by going to Formulas > Name Manager."]
[]
[{"$nulls":3},"In this example, the NETWORKDAYS.INTL "]
[{"$nulls":3},"function calculates the number of workdays:"]
[{"$nulls":3},"Start date","End date","Result"]
[{"$nulls":3},"2016-01-01","2016-12-31",{"$f":"NETWORKDAYS.INTL(D53,E53,1,MyHolidays)","v":252}]
[]
[{"$nulls":3},"In Excel 2007, you can use the NETWORKDAYS"]
[{"$nulls":3},"function to calculate the number of workdays:"]
[{"$nulls":3},"Start date","End date","Result"]
[{"$nulls":3},"2016-01-01","2016-12-31",{"$f":"NETWORKDAYS(D58,E58,MyHolidays)","v":252}]
[]
[]
[{"$nulls":3},"If you want your holidays inside a formula,"]
[{"$nulls":3},"you can use extra brackets, quotes, and commas."]
[]
[{"$nulls":3},"This highlighted cell shows an example"]
[{"$nulls":3},"of 2 holiday dates within the formula:"]
[{"$nulls":3},"Start date","End date","Result"]
[{"$nulls":3},"2016-01-01","2016-12-31",{"$f":"NETWORKDAYS.INTL(D67,E67,1,{\"1/1/2016\",\"1/2/2016\"})","v":260}]
[]
[{"$nulls":3},"And here's an Excel 2007 example of"]
[{"$nulls":3},"of 2 holiday dates within the formula:"]
[{"$nulls":3},"Start date","End date","Result"]
[{"$nulls":3},"2016-01-01","2016-12-31",{"$f":"NETWORKDAYS(D72,E72,{\"1/1/2016\",\"1/2/2016\"})","v":260}]
[]
[]
[]
[]
[]
["Calculate the difference"]
["between two times:",null,null,"Start time","End time","Difference"]
[{"$nulls":3},"07:15:00","16:30:00",{"$f":"E80-D80","v":"09:15:00"}]
[]
["Calculate the difference"]
["between two times:",null,null,"Start date/time","End date/time","Difference"]
[{"$nulls":3},"2016-01-01T13:00:00","2016-01-02T14:00:00",{"$f":"E84-D84","v":1.0416666666715173}]