---
schema_version: "1"
id: f6f375ad2b9b355332403bf23ddce01a72ffc8ea1bf61127ad015df0d1674a40
title: Add or Subtract Days or Months
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_batch_transform_add_subtract_time.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_add_subtract_time.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: fb7692f12a29a4ca1a7b30750de677406c1a546c17fd42f1dea9d7f96a8e841e
description: Return the column date with the specified days or months added or removed.
products:
  - Data 360
release: "264"
---
# Add or Subtract Days or Months

Return the column date with the specified days or months added or removed.

1. In a Transform node, select one date column in the Preview tab.
2. Select the Formula button (![Formula button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_integrate_recipe_transformation_formula.png)) in the Transform toolbar.
3. Select **Add or Subtract Days or Months**.
4. Configure the transformation.
    
    ![Configure the Add or Subtract Days or Months function.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_integrate_date_difference.png)
    
    1. The Start Date Column is automatically filled with the date column you previously chose. To choose a different start date, cancel and restart.
    2. To add or subtract, choose **Days** or **Months**.
    3. Select the number to add or subtract with the plus and minus buttons.
    4. Choose the date format of the output column.
5. Optionally, change the label of the column that stores the result data in the Column Label field.
6. To add the transformation to the Transform node, click **Apply**. The Preview tab shows the new calculated date column.
    
    ![Preview shows the new calculated date column.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_integrate_calculated_date_outcome.png)
7. To view the canvas area, click the Collapse button (![Collapse button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_button_collapse.png)).