{"id":7113,"date":"2025-04-04T14:54:17","date_gmt":"2025-04-04T14:54:17","guid":{"rendered":"https:\/\/powergi.net\/?p=7113"},"modified":"2025-09-09T21:43:20","modified_gmt":"2025-09-09T21:43:20","slug":"calculate-business-days-between-two-dates-in-power-automate","status":"publish","type":"post","link":"https:\/\/powergi.net\/es\/blog\/calculate-business-days-between-two-dates-in-power-automate\/","title":{"rendered":"Calculate Business Days between two dates in Power Automate"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"7113\" class=\"elementor elementor-7113\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-63b83ae elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"63b83ae\" data-element_type=\"section\" data-e-type=\"section\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f35648f\" data-id=\"f35648f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0cc22bd elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"0cc22bd\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings='{\"exclude_headings_by_selector\":[],\"no_headings_message\":\"No headings were found on this page.\",\"headings_by_tags\":[\"h2\",\"h3\",\"h4\",\"h5\",\"h6\"],\"marker_view\":\"numbers\",\"minimize_box\":\"yes\",\"minimized_on\":\"tablet\",\"hierarchical_view\":\"yes\",\"min_height\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"min_height_tablet\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"min_height_mobile\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]}}' data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTable of Contents\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__0cc22bd\" aria-expanded=\"true\" aria-label=\"Inhaltsverzeichnis \u00f6ffnen\"><i aria-hidden=\"true\" class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__0cc22bd\" aria-expanded=\"true\" aria-label=\"Inhaltsverzeichnis schlie\u00dfen\"><i aria-hidden=\"true\" class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<div id=\"elementor-toc__0cc22bd\" class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9ee57d0 elementor-widget elementor-widget-text-editor\" data-id=\"9ee57d0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Calculating the number of business days between two dates is a common requirement in the world of automation, sometimes we want to send reminders every 3 or 5 business days, and not calendar days. In this blog, we\u2019ll show you how to use <\/span><a href=\"https:\/\/powergi.net\/\" target=\"_blank\" rel=\"noopener\"><b>Power Automate<\/b><\/a><span style=\"font-weight: 400;\"> to calculate the difference in business days.<\/span><\/p><p>If your team is looking to streamline these types of processes, leveraging professional <a href=\"https:\/\/powergi.net\/microsoft-power-platform-consulting-services\/\"><strong>Power Apps Consulting Services<\/strong><\/a> can help ensure your flows are optimized, reliable, and aligned with your organization\u2019s automation strategy.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7d05540 elementor-widget elementor-widget-heading\" data-id=\"7d05540\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Step 1. Create an instant flow with two date inputs <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a2c6123 elementor-widget elementor-widget-text-editor\" data-id=\"a2c6123\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW93833689 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW93833689 BCX0\">Select \u201cAdd an input\u201d<\/span><\/span><span class=\"EOP SCXW93833689 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-21bbb7a elementor-widget elementor-widget-image\" data-id=\"21bbb7a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"504\" height=\"169\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-100.png\" class=\"attachment-large size-large wp-image-7115\" alt=\"Add an Input Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-100.png 504w, https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-100-300x101.png 300w\" sizes=\"(max-width: 504px) 100vw, 504px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4354846 elementor-widget elementor-widget-text-editor\" data-id=\"4354846\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW82786352 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW82786352 BCX0\">Select \u201cDate\u201d<\/span><\/span><span class=\"EOP SCXW82786352 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9977b1f elementor-widget elementor-widget-image\" data-id=\"9977b1f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"507\" height=\"130\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163020.412.png\" class=\"attachment-large size-large wp-image-7116\" alt=\"Type of User Input Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163020.412.png 507w, https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163020.412-300x77.png 300w\" sizes=\"(max-width: 507px) 100vw, 507px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f9bcc15 elementor-widget elementor-widget-text-editor\" data-id=\"f9bcc15\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW80928626 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW80928626 BCX0\">End result<\/span><span class=\"NormalTextRun SCXW80928626 BCX0\"> should look like this:<\/span><\/span><span class=\"EOP SCXW80928626 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ce97288 elementor-widget elementor-widget-image\" data-id=\"ce97288\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"499\" height=\"225\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163059.395.png\" class=\"attachment-large size-large wp-image-7117\" alt=\"User Input End Result Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163059.395.png 499w, https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163059.395-300x135.png 300w\" sizes=\"(max-width: 499px) 100vw, 499px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-60d6395 elementor-widget elementor-widget-heading\" data-id=\"60d6395\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Step 2. Write the Power Fx function to calculate the difference in calendar days between the two dates. <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a8b03b9 elementor-widget elementor-widget-text-editor\" data-id=\"a8b03b9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span data-contrast=\"auto\">We can use the dateDifference function and pass the start and end date. Then just convert this result to an integer by extracting the number of days from the result.<\/span><\/p><div id=\"seology-cta-1\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7276\" class=\"elementor elementor-7276\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-7e3f164 e-con-full e-flex e-con e-parent\" data-id=\"7e3f164\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"background_background\":\"classic\",\"jet_parallax_layout_list\":[]}'>\n\t\t<div class=\"elementor-element elementor-element-9078c9f e-con-full e-flex e-con e-child\" data-id=\"9078c9f\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b99949 elementor-widget elementor-widget-heading\" data-id=\"7b99949\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">From vision to execution<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e61db5 elementor-widget elementor-widget-heading\" data-id=\"8e61db5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Whether you're just starting or scaling automation, we help turn your ideas into impactful solutions.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a578907 e-flex e-con-boxed e-con e-child\" data-id=\"a578907\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c827b elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"e8c827b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"#ctc_chat\">\n\t\t\t<i aria-hidden=\"true\" class=\"fab fa-whatsapp\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d834237 elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"d834237\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"https:\/\/powergi.net\/es\/contact\/\">\n\t\t\t<i aria-hidden=\"true\" class=\"far fa-envelope\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9692a8e elementor-widget elementor-widget-code-highlight\" data-id=\"9692a8e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>int(split(dateDifference(formatDateTime(triggerBody()['date'],'yyyy-MM-dd'),formatDateTime(triggerBody()['date_1'],'yyyy-MM-dd')),':')?[0])\u00a0<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3057d61 elementor-widget elementor-widget-heading\" data-id=\"3057d61\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Step 3. Use the Range Power Fx function \n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7420512 elementor-widget elementor-widget-text-editor\" data-id=\"7420512\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span data-contrast=\"auto\">Next, we can use the Range function in Power Automate to generate a list that covers every single day in between each date.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-51bf211 elementor-widget elementor-widget-code-highlight\" data-id=\"51bf211\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>range(0,int(split(dateDifference(formatDateTime(triggerBody()['date'],'yyyy-MM-dd'),formatDateTime(triggerBody()['date_1'],'yyyy-MM-dd')),':')?[0]))\u00a0<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0b08ea2 elementor-widget elementor-widget-text-editor\" data-id=\"0b08ea2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span data-contrast=\"auto\">The result of above function will look like below \u2013 the number of items in the result will depend on the number of days in between each day:<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">[0,1,2,3,4,5]<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e802d6b elementor-widget elementor-widget-heading\" data-id=\"e802d6b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Step 4. Add a Select action <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-10627f7 elementor-widget elementor-widget-text-editor\" data-id=\"10627f7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW169350520 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW169350520 BCX0\">Add a new step in the flow and find the \u201cSelect\u201d action. Once selected, in the \u201cFrom\u201d field, write the complete formula we created on step #3<\/span><\/span><span class=\"EOP SCXW169350520 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4fd8333 elementor-widget elementor-widget-text-editor\" data-id=\"4fd8333\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW38049804 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW38049804 BCX0\">It should look like this:<\/span><\/span><span class=\"EOP SCXW38049804 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-451a35d elementor-widget elementor-widget-code-highlight\" data-id=\"451a35d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>range(0,int(split(dateDifference(formatDateTime(triggerBody()['date'],'yyyy-MM-dd'),formatDateTime(triggerBody()['date_1'],'yyyy-MM-dd')),':')?[0])) <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-529a641 elementor-widget elementor-widget-image\" data-id=\"529a641\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"382\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163505.271.png\" class=\"attachment-large size-large wp-image-7118\" alt=\"Manually Trigger a Flow Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163505.271.png 512w, https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163505.271-300x224.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-67a6e4c elementor-widget elementor-widget-text-editor\" data-id=\"67a6e4c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">In the Map field, add the following formula:\u00a0<\/span><span style=\"font-weight: 400;\">\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">if(or(equals(dayOfWeek(addDays(formatDateTime(triggerBody()[\u2018date\u2019],\u2019yyyy\/MM\/dd\u2019),add(item(),1))),0),\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">equals(\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">dayOfWeek(addDays(formatDateTime(triggerBody()[\u2018date\u2019],\u2019yyyy\/MM\/dd\u2019),add(item(),1))),6)),0,1)\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">With above formula, we\u2019re checking if each date in between the two dates we are comparing falls on a Saturday or Sunday. If Sunday or Saturday it will return 0, if something different from those two, it will return a 1. <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f25cb94 elementor-widget elementor-widget-image\" data-id=\"f25cb94\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"495\" height=\"132\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163642.075.png\" class=\"attachment-large size-large wp-image-7119\" alt=\"Map Field Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163642.075.png 495w, https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163642.075-300x80.png 300w\" sizes=\"(max-width: 495px) 100vw, 495px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-55ced65 elementor-widget elementor-widget-text-editor\" data-id=\"55ced65\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">If we run the automation as it is right now, we should get this result:\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-68a106c elementor-widget elementor-widget-image\" data-id=\"68a106c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"338\" height=\"512\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163751.431.png\" class=\"attachment-large size-large wp-image-7120\" alt=\"Input and Output Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163751.431.png 338w, https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-2025-03-31T163751.431-198x300.png 198w\" sizes=\"(max-width: 338px) 100vw, 338px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7bef61c elementor-widget elementor-widget-text-editor\" data-id=\"7bef61c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">We\u2019re comparing March 28<\/span><span style=\"font-weight: 400;\">th<\/span><span style=\"font-weight: 400;\"> of 2025 and April 25<\/span><span style=\"font-weight: 400;\">th<\/span><span style=\"font-weight: 400;\"> exclusively.\u00a0\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">When we check the calendar, there are 5 working days and 3 non-work days. <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-955b443 elementor-widget elementor-widget-image\" data-id=\"955b443\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"330\" height=\"339\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-72-1.png\" class=\"attachment-large size-large wp-image-7135\" alt=\"March Calendar Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-72-1.png 330w, https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-72-1-292x300.png 292w\" sizes=\"(max-width: 330px) 100vw, 330px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e30f75 elementor-widget elementor-widget-text-editor\" data-id=\"4e30f75\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">In the results we can notice the first two values are 0 \u2013 because they are non-working days. When the date falls on a work day, it returns zero.\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-64b9146 elementor-widget elementor-widget-heading\" data-id=\"64b9146\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Step 5. Sum working days \n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ac98c3 elementor-widget elementor-widget-text-editor\" data-id=\"0ac98c3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Since all dates that relate to working days return a \u201c1\u201d, we can just sum all the values in the result to obtain the number of working days.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">For that, let\u2019s just add a compose action and use the following Power Fx function\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">xpath(xml(json(concat(\u2018{\u00a0 \u201croot\u201d: {\u00a0 \u00a0 \u201cNumbers\u201d: \u2018,body(\u2018Select\u2019),\u2019 }}\u2019))), \u2018sum(\/root\/Numbers)\u2019)\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">This will take the results from the Select action, convert them to XLM and finally sum them using the xpath function.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Action should like this: <\/span><\/p><div id=\"seology-cta-2\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7283\" class=\"elementor elementor-7283\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-7e3f164 e-con-full e-flex e-con e-parent\" data-id=\"7e3f164\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"background_background\":\"classic\",\"jet_parallax_layout_list\":[]}'>\n\t\t<div class=\"elementor-element elementor-element-9078c9f e-con-full e-flex e-con e-child\" data-id=\"9078c9f\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b99949 elementor-widget elementor-widget-heading\" data-id=\"7b99949\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Is your business ready for automation?<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e61db5 elementor-widget elementor-widget-heading\" data-id=\"8e61db5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Automate processes with Microsoft Power Platform.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a578907 e-flex e-con-boxed e-con e-child\" data-id=\"a578907\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c827b elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"e8c827b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"#ctc_chat\">\n\t\t\t<i aria-hidden=\"true\" class=\"fab fa-whatsapp\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d834237 elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"d834237\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"https:\/\/powergi.net\/es\/contact\/\">\n\t\t\t<i aria-hidden=\"true\" class=\"far fa-envelope\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8da699a elementor-widget elementor-widget-image\" data-id=\"8da699a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"94\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-71.png\" class=\"attachment-large size-large wp-image-7134\" alt=\"Select Action Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-71.png 494w, https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-71-300x57.png 300w\" sizes=\"(max-width: 494px) 100vw, 494px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d44b6b2 elementor-widget elementor-widget-heading\" data-id=\"d44b6b2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Step 6. Test the automation <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e11a03 elementor-widget elementor-widget-text-editor\" data-id=\"6e11a03\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">When testing, the result will be 5: <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2312d4c elementor-widget elementor-widget-image\" data-id=\"2312d4c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"238\" height=\"512\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-70-1.png\" class=\"attachment-full size-full wp-image-7127\" alt=\"Automation Test Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-70-1.png 238w, https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-70-1-139x300.png 139w\" sizes=\"(max-width: 238px) 100vw, 238px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-35aa268 elementor-widget elementor-widget-text-editor\" data-id=\"35aa268\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">This is how the final flow should look:\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-96c3870 elementor-widget elementor-widget-image\" data-id=\"96c3870\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"414\" height=\"401\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-69-1.png\" class=\"attachment-large size-large wp-image-7126\" alt=\"Manually Trigger a Flow Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-69-1.png 414w, https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-69-1-300x291.png 300w\" sizes=\"(max-width: 414px) 100vw, 414px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-890229d elementor-widget elementor-widget-heading\" data-id=\"890229d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Bonus: Add this flow as a child flow \n<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cb30ff9 elementor-widget elementor-widget-text-editor\" data-id=\"cb30ff9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">If you want to be able to call this flow from different other flows or from <strong><a href=\"https:\/\/powergi.net\/blog\/use-the-select-function-to-re-use-some-pieces-of-code-in-canvas-apps-power-apps-code-blocks-and-reusability\/\" target=\"_blank\" rel=\"noopener\">Power Apps<\/a><\/strong>, we can add the \u201cRespond to a Power App or flow\u201d action, and add the xpath formula there instead.\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dad66e6 elementor-widget elementor-widget-image\" data-id=\"dad66e6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"419\" height=\"452\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-68-1.png\" class=\"attachment-large size-large wp-image-7125\" alt=\"Power App or Flow Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-68-1.png 419w, https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-68-1-278x300.png 278w\" sizes=\"(max-width: 419px) 100vw, 419px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4d081eb elementor-widget elementor-widget-text-editor\" data-id=\"4d081eb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">You should be able to call this flow from multiple places now:\u00a0<\/span><span style=\"font-weight: 400;\"><br><\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-03ca87a elementor-widget elementor-widget-image\" data-id=\"03ca87a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"433\" height=\"337\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-67-1.png\" class=\"attachment-large size-large wp-image-7124\" alt=\"Child Flow Business Days Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-67-1.png 433w, https:\/\/powergi.net\/wp-content\/uploads\/2025\/03\/unnamed-67-1-300x233.png 300w\" sizes=\"(max-width: 433px) 100vw, 433px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d0d8950 elementor-widget elementor-widget-text-editor\" data-id=\"d0d8950\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Power Automate doesn\u2019t have a built-in feature for calculating business days, but we can achieve this calculation by combining Power Fx functions with out-of-the-box actions. We can also create a \u201cchild flow\u201d that can perform this calculation \u201con-demand\u201d and can be called from other flows or even from Power Apps.\u00a0<\/span><\/p><p><strong><a href=\"https:\/\/powergi.net\/contact\/\" target=\"_blank\" rel=\"noopener\">Contact us<\/a><\/strong><span style=\"font-weight: 400;\"> if you have any questions or if you\u2019d like some help on Power Automate or PowerFx!\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Table of Contents Calculating the number of business days between two dates is a common requirement in the world of automation, sometimes we want to send reminders every 3 or 5 business days, and not calendar days. In this blog, we\u2019ll show you how to use Power Automate to calculate the difference in business days. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":7110,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"glossary_letter":"","footnotes":""},"categories":[81,85],"tags":[157,17],"class_list":["post-7113","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-apps-cat","category-power-automate-cat","tag-power-apps","tag-power-automate"],"glossary_letter":null,"rank_math_title":"Power Automate | Power Apps | Power GI ","rank_math_description":"Automate business day calculations in Power Automate with this guide. Learn how to subtract weekends and count only workdays between two dates.","rank_math_focus_keyword":"Power Automate","_links":{"self":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts\/7113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/comments?post=7113"}],"version-history":[{"count":0,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts\/7113\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/media\/7110"}],"wp:attachment":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/media?parent=7113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/categories?post=7113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/tags?post=7113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}