ClickUp – Adding 14 days to a specific date field (column)

Are you setting up ClickUp templates with formulas for your team? Add this formula in one of our expert-created ClickUp templates.

See our ClickUp templates

ClickUp Formula: Adding 14 days to a specific date field (column)

The formula is:

DATE(YEAR(field("Due date")),MONTH(field("Due date")),DAY(field("Due date"))+14)

↑ Copy and paste into ClickUp then switch out the bold property name/s in the formula to match the name of the property name/s you’re using.

 

How to create a date formula in ClickUp

The steps to creating a date formula in ClickUp are:

  1. Create a ClickUp List
  2. Ensure your board is set up in List or Table view
  3. Add a column by clicking on the + icon to the right of the existing column name
  4. Select Date
  5. You can choose to add an extra date column to set up a formula between the two columns or use a single column
  6. Add another column and scroll down to select Formula
  7. Add a Field Name and click Add Column
  8. Hover over the column and click the fx icon
  9. Add your formula in the simple editor box and then click Calculate or select the Advanced Editor to add your formula/select Calculate

 

How to edit a date formula in ClickUp

The steps to editing a date formula in ClickUp are:

  1. Hover over the column and click on any field
  2. Add your new formula in the box and then click Calculate