Add AI or Automation Support for Recurring Period Date Ranges

[HugoPhilibert (Philibert)]

Description

Hello Monday team

I would like to suggest an improvement regarding the “Period” column (date range).

Currently, when using this column for recurring operational planning (e.g. weekly team planning), the period has to be entered manually each time. In my case, I use it every week to plan team workload, which means I repeatedly create the same type of date range (for example: Monday → Friday of the same week).

It would be extremely helpful to:

-Integrate AI support within the Period column to automatically generate recurring date ranges (e.g. “next week”, “current week”, “every Monday–Friday”, etc.),
or

• Allow this to be handled through automations, such as:
  When item is created → set Period to current week
  When status changes → set Period to next week
  Create recurring items with an automatically updated date range

Right now, this repetitive manual entry adds unnecessary friction in what is otherwise a highly structured planning workflow.
Thanks in advance for considering this.

What are you trying to achieve

I want to streamline weekly team planning by automatically generating recurring date ranges in the Period column.

Currently, I have to manually enter the same weekly date range (e.g., Monday to Friday) for each new planning item. My goal is to eliminate repetitive manual input, reduce errors, and standardize recurring weekly scheduling.

[YOGESHP (Yogesh Pokale)]

Hi @HugoPhilibert,

Welcome to the community!

Note: Since this solution uses the Workflow builder, it will only work on Pro and Enterprise plans.

You can achieve this by using:

• A Status column (This Week / Next Week)

• Two Formula columns to calculate the Monday start and Friday end dates based on the selected status

  Start Date: IF(
  {Week} = “This Week”,
  FORMAT_DATE(
  ADD_DAYS(TODAY(),
  IF(WEEKDAY(TODAY()) = 1, -6, 2 - WEEKDAY(TODAY()))
  ),
  “DD-MM-YYYY”),
  IF(
  {Week} = “Next Week”,
  FORMAT_DATE(
  ADD_DAYS(TODAY(),
  IF(WEEKDAY(TODAY()) = 1, 1, 9 - WEEKDAY(TODAY()))
  ),
  “DD-MM-YYYY”),
  “”
  )
  )

  End Date: IF(
  {Week} = “This Week”,
  FORMAT_DATE(
  ADD_DAYS(TODAY(), 4 - MOD(WEEKDAY(TODAY()) + 5, 7)),
  “DD-MM-YYYY”
  ),
  IF(
  {Week} = “Next Week”,
  FORMAT_DATE(
  ADD_DAYS(TODAY(), 11 - MOD(WEEKDAY(TODAY()) + 5, 7)),
  “DD-MM-YYYY”
  ),
  “”
  )
  )

Then build a workflow like this:

• Trigger: When any item column changes (My Setup)

  • You can also use When Status changes, when item is created, or any trigger that best fits your process

• Get item data

• Convert Formula start date (text) → Date

• Convert Formula end date (text) → Date

• Update the Timeline column with those converted values

This pushes the calculated dates into your Timeline column so you can reference it in Workload and other visuals. Let me know if you need help setting this up!