{"id":13,"date":"2007-11-02T14:33:57","date_gmt":"2007-11-02T21:33:57","guid":{"rendered":"http:\/\/shivdev.com\/blog\/2007\/11\/02\/truncate-a-date-to-first-of-the-month\/"},"modified":"2007-11-02T17:42:05","modified_gmt":"2007-11-03T00:42:05","slug":"truncate-a-date-to-first-of-the-month","status":"publish","type":"post","link":"http:\/\/shivdev.com\/blog\/2007\/11\/02\/truncate-a-date-to-first-of-the-month\/","title":{"rendered":"Truncate A Date to First of the Month"},"content":{"rendered":"<p>Want to convert <strong>1\/20\/2007<\/strong> to <strong>1\/1\/2007<\/strong> in Excel?<br \/>\nUse the <strong><em>DATE <\/em><\/strong>excel function.<\/p>\n<blockquote><p>=DATE(YEAR(A1),MONTH(A1),1)<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Want to convert 1\/20\/2007 to 1\/1\/2007 in Excel? Use the DATE excel function. =DATE(YEAR(A1),MONTH(A1),1)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"_links":{"self":[{"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/posts\/13"}],"collection":[{"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/comments?post=13"}],"version-history":[{"count":0,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/posts\/13\/revisions"}],"wp:attachment":[{"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/media?parent=13"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/categories?post=13"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/tags?post=13"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}