{"id":844,"date":"2018-01-15T12:30:45","date_gmt":"2018-01-15T12:30:45","guid":{"rendered":"http:\/\/blogs-new.it.ox.ac.uk\/do\/?p=844"},"modified":"2018-02-16T09:23:26","modified_gmt":"2018-02-16T09:23:26","slug":"do-why-is-easter-early-this-year-an-excel-adventure-in-dates-times","status":"publish","type":"post","link":"https:\/\/blogs-new.it.ox.ac.uk\/do\/do-why-is-easter-early-this-year-an-excel-adventure-in-dates-times\/","title":{"rendered":"do: Why is Easter early this year? An Excel adventure in dates &amp; times"},"content":{"rendered":"<p>This <span style=\"border: 2px solid #007770\"><span style=\"color: #007770;font-family: 'courier new';font-weight: 900\">do<\/span><span style=\"color: #007770;font-weight: 900\">:<\/span><\/span> talk is for anybody who uses dates and times in their Excel work. We will explore functions, formulas and formats that are under-appreciated, or even hidden:<\/p>\n<p><span style=\"color: #000000\">Display more than 24 hrs in a cell <\/span><\/p>\n<p><span style=\"color: #000000\">Discover custom date\/time formats<\/span><\/p>\n<p><span style=\"color: #000000\">Construct working date calculations<\/span><\/p>\n<p><span style=\"color: #000000\">Try the Fill Handle with Dates<\/span><\/p>\n<p><span style=\"color: #000000\">Use a hidden Excel date function<\/span><\/p>\n<p><span style=\"color: #000000\">How To Calculate the date of Easter<\/span><\/p>\n<p>\u2014\u2014\u2014-<\/p>\n<p><span style=\"color: #339966\"><em>Speaker: Duncan Young<\/em><\/span><\/p>\n<p>\u2014\u2014\u2014-<\/p>\n<p>Duncan has made some of the resources from his talk available for download:<\/p>\n<p><a href=\"http:\/\/portfolio.it.ox.ac.uk\/sites\/itlpportfolio\/files\/publicly-viewable\/Easter%202018.pptx\">slides<\/a><\/p>\n<p>time calculations <a href=\"http:\/\/portfolio.it.ox.ac.uk\/sites\/itlpportfolio\/files\/publicly-viewable\/Time%20Formulas%20%28start%29.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\">start<\/a> \/ <a href=\"http:\/\/portfolio.it.ox.ac.uk\/sites\/itlpportfolio\/files\/publicly-viewable\/Time%20Formulas.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\">complete<\/a><\/p>\n<p>date calculations <a href=\"http:\/\/portfolio.it.ox.ac.uk\/sites\/itlpportfolio\/files\/publicly-viewable\/Date%20Formulas%20%28start%29.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\">start<\/a> \/ <a href=\"http:\/\/portfolio.it.ox.ac.uk\/sites\/itlpportfolio\/files\/publicly-viewable\/Date%20Formulas.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\">complete<\/a><\/p>\n<p><a href=\"https:\/\/ox.cloud.panopto.eu\/Panopto\/Pages\/Viewer.aspx?id=80332e00-0138-4b75-a5e4-a87000c51e8c\" target=\"_blank\" rel=\"noopener noreferrer\">watch the recorded talk<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This do: talk is for anybody who uses dates and times in their Excel work. We will explore functions, formulas and formats that are under-appreciated, or even hidden: Display more than 24 hrs in a cell Discover custom date\/time formats &hellip; <a href=\"https:\/\/blogs-new.it.ox.ac.uk\/do\/do-why-is-easter-early-this-year-an-excel-adventure-in-dates-times\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":269,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38823],"tags":[],"class_list":["post-844","post","type-post","status-publish","format-standard","hentry","category-38823"],"_links":{"self":[{"href":"https:\/\/blogs-new.it.ox.ac.uk\/do\/wp-json\/wp\/v2\/posts\/844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs-new.it.ox.ac.uk\/do\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs-new.it.ox.ac.uk\/do\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs-new.it.ox.ac.uk\/do\/wp-json\/wp\/v2\/users\/269"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs-new.it.ox.ac.uk\/do\/wp-json\/wp\/v2\/comments?post=844"}],"version-history":[{"count":13,"href":"https:\/\/blogs-new.it.ox.ac.uk\/do\/wp-json\/wp\/v2\/posts\/844\/revisions"}],"predecessor-version":[{"id":893,"href":"https:\/\/blogs-new.it.ox.ac.uk\/do\/wp-json\/wp\/v2\/posts\/844\/revisions\/893"}],"wp:attachment":[{"href":"https:\/\/blogs-new.it.ox.ac.uk\/do\/wp-json\/wp\/v2\/media?parent=844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs-new.it.ox.ac.uk\/do\/wp-json\/wp\/v2\/categories?post=844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs-new.it.ox.ac.uk\/do\/wp-json\/wp\/v2\/tags?post=844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}