Others

How to Create a Microsoft Planner Task for the Last Weekday of Each Month

Steve K Sep 25, 2026 869 views

Question details

The user needs to schedule a recurring task in Microsoft Planner that automatically generates on the last weekday or business day of every month.

Create a Microsoft Planner Task for the Last Weekday of Each Month

Product: Microsoft Planner
Device & OS: not provided
Scenario: Setting up automated monthly task management workflows for end-of-month business operations.
Observed behavior: Microsoft Planner does not offer a built-in recurrence pattern for the last weekday or business day of the month.

Before you start

Verify that you have an active Microsoft 365 subscription with access to Microsoft Power Automate, as setting up advanced scheduling logic requires creating a custom cloud flow.

Solution 1Recommended

Automate Task Creation using Power Automate

Since Planner lacks a native 'last weekday' trigger, you can build a scheduled cloud flow in Power Automate to evaluate the date and automatically create the task.

Power Automate connects directly with Microsoft Planner and allows you to use expressions to calculate whether the current day is the last business day of the month before generating a task.

Create a Scheduled Cloud Flow

Open Microsoft Power Automate, navigate to 'Create', and select 'Scheduled cloud flow'. Set the recurrence frequency to run 'Daily' or 'Monthly' based on your preference.

Add a Condition for the Last Weekday

Insert a 'Condition' step. Use dynamic content and expressions (such as combining addDays, startOfMonth, and dayOfWeek functions) to check if today's date matches the last weekday of the current month.

Configure the Planner Action

In the 'If yes' branch, add the 'Create a task' action for Microsoft Planner. Select the Group ID, Plan ID, and assign a title to the new task.

Test and Save the Flow

Save your flow and use the 'Test' feature to ensure it successfully generates a test task in your specified Planner bucket.

Automate Task Creation using Power Automate

Pre-built Templates: You can often find community-created templates in the Power Automate library by searching for 'last business day of month' to save time on configuring complex date expressions.

Solution 2

Set a Calendar Reminder to Manually Duplicate the Task

If you do not want to use Power Automate, you can use Outlook's robust calendar recurrence to remind you to manually copy a template task in Planner.

Free Microsoft Office alternative

Manage Projects and Schedules Flexibly with WPS Office

While Microsoft Planner requires complex workarounds for specific scheduling rules, you can easily track recurring tasks, deadlines, and project milestones using customizable spreadsheet templates in WPS Office. It provides a familiar, lightweight, and fully compatible alternative for all your daily productivity needs.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your preferred device.
2. Access Free Templates: Open WPS Office and navigate to the Template library. Search for 'Task Management' or 'Project Tracker'.
3. Customize Your Tracker: Apply the template in WPS Spreadsheet and easily customize date columns and conditional formatting to highlight end-of-month deadlines.

Easily track monthly and recurring tasks using highly flexible Spreadsheet templatesSeamless compatibility with Microsoft Office formats like .xlsx, .docx, and .pptxFree, lightweight, and features a familiar user interface for quick adoptionIntegrated toolkit for documents, spreadsheets, presentations, and PDFs

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Microsoft Planner have a native 'last weekday' option?

Microsoft Planner is designed for basic task scheduling. Its native recurrence settings only support simple daily, weekly, monthly, and yearly intervals. Complex calendar logic requires integrating with advanced automation tools like Power Automate.

Can I use third-party tools to automate Microsoft Planner tasks?

Yes. If you prefer not to use Power Automate, third-party automation platforms like Zapier or Make can connect to your Microsoft account and trigger the creation of Planner tasks based on complex date rules.

How do I easily duplicate a task in Planner instead of recreating it?

In your Planner board, click the three dots (More options) on the specific task you want to duplicate. Select 'Copy task', choose which details (like checklist items, attachments, or assignments) to include, and select the target bucket.

Office Quick Solutions