Formula assistance to calculate Workdays vs Calendar Days based on Status

Platform discussions
,
1

I’m trying to create a formula that would calculate a date based on a status column that would identify if it should be calculated for work days vs regular days.

In the example attached:
IF {Due Date Criteria} = “BD”, then calculate Workdays by adding {Days} to the {Month}
and in the same format as Month column, so the result should be May 28, 2024
IF {Due Date Criteria} = “CD”, then Add {Days} to the {Month} and in the same format as the month column.

image
image1369×225 23 KB

2

Hi Sofia,

Try

IF({Due Date Criteria}="BD",WORKDAY({Month},{Days}),ADD_DAYS({Month},{Days}))

 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.