{"id":221,"date":"2014-12-09T11:59:00","date_gmt":"2014-12-09T11:59:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2014\/12\/09\/powertip-use-powershell-to-determine-weeks-between-dates\/"},"modified":"2019-02-18T10:36:40","modified_gmt":"2019-02-18T17:36:40","slug":"powertip-use-powershell-to-determine-weeks-between-dates","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/powertip-use-powershell-to-determine-weeks-between-dates\/","title":{"rendered":"PowerTip: Use PowerShell to Determine Weeks Between Dates"},"content":{"rendered":"<p><b style=\"font-size:12px\">Summary<\/b><span style=\"font-size:12px\">: Use Windows PowerShell to determine the number of weeks between two dates.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" alt=\"Hey, Scripting Guy! Question\" \/>&nbsp;I have a project that is broken into several major components of work. I know the start date of the project and <br \/>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;the end date of the project. How can I use Windows PowerShell to determine the number of weeks between <br \/>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;these dates so I can determine how many weeks to allocate for each milestone?<\/p>\n<p style=\"margin-left:30px\"><img decoding=\"async\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" alt=\"Hey, Scripting Guy! Answer\" \/>&nbsp;Use the&nbsp;<b>New-TimeSpan<\/b>&nbsp;cmdlet to create a timespan object that represents the amount of time between <br \/>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;the start date and the end date. Then divide the&nbsp;<b>Days<\/b><i>&nbsp;<\/i>property by seven to determine the number of weeks. <br \/>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Here is an example:<\/p>\n<p style=\"margin-left:120px\">PS C:\\&gt; $ts = New-TimeSpan -Start 1\/5\/2015 -End 5\/25\/15<span style=\"font-size:12px\">&nbsp;<\/span><\/p>\n<p style=\"margin-left:120px\">PS C:\\&gt; $ts.Days \/ 7<\/p>\n<p style=\"margin-left:120px\">20<\/p>\n<p style=\"margin-left:60px\"><img decoding=\"async\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/7610.Dr.ScriptoForTips.jpg\" alt=\" \" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Summary: Use Windows PowerShell to determine the number of weeks between two dates. &nbsp;I have a project that is broken into several major components of work. I know the start date of the project and &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;the end date of the project. How can I use Windows PowerShell to determine the [&hellip;]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[356,3,45],"class_list":["post-221","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-powertip","tag-scripting-guy","tag-windows-powershell"],"acf":[],"blog_post_summary":"<p>Summary: Use Windows PowerShell to determine the number of weeks between two dates. &nbsp;I have a project that is broken into several major components of work. I know the start date of the project and &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;the end date of the project. How can I use Windows PowerShell to determine the [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=221"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/221\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}