{"id":388,"date":"2014-06-17T15:13:03","date_gmt":"2014-06-17T15:13:03","guid":{"rendered":"http:\/\/xlfxs.com\/?p=388"},"modified":"2014-06-17T15:13:03","modified_gmt":"2014-06-17T15:13:03","slug":"week-number-to-date-reverse-weeknum","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=388","title":{"rendered":"Week number to Sunday date &#8211; Weeknum reverse"},"content":{"rendered":"<p>This was a request from one of my work managers<br \/>\nShe wanted to convert a week number she got in a column into thier dates<\/p>\n<p>Excel already have the WEEKNUM that converts a date into its week number, but the reverse is what needed here<\/p>\n<p>So after my mouth was drooling while she was asking her question, I started a head, and below is the result formula<\/p>\n<p>You just need to place the week number in cell B3, then paste this formula anywhere:<\/p>\n<p><!--more--><\/p>\n<pre>=IF(B3&lt;2,DATE(YEAR(TODAY()),1,1),DATE(YEAR(TODAY()),1,1)-WEEKDAY(DATE(YEAR(TODAY()),1,1))+((B3-1)*7)+1) <\/pre>\n<p><a class=\"fancybox\" href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2014\/12\/B2014-10-02WeeknumReverse.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-389\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2014\/12\/B2014-10-02WeeknumReverse-300x107.png\" alt=\"B2014-10-02WeeknumReverse\" width=\"300\" height=\"107\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This was a request from one of my work managers She wanted to convert a week number she got in a column into thier dates Excel already have the WEEKNUM that converts a date into its week number, but the reverse is what needed here So after my mouth was drooling while she was asking&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=388\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Week number to Sunday date &#8211; Weeknum reverse&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":389,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[76,23,3,6,61,63,64,65],"tags":[],"class_list":["post-388","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-date","category-date-and-time","category-formulas","category-standard_functions","category-today","category-weekday","category-weeknum","category-year"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=388"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/388\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/389"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}