---
schema_version: "1"
id: 651f13ee2c68b2d421334759db77b154ee1e2f60ff7e80e973a9b246b342e6a5
title: Add or Subtract Days or Months
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_recipe_add_subtract_time.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_add_subtract_time.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b7df0d73453a8bc9e22010679041ac6db2bd9cdc4da4dab8e1f222cba9dfd362
description: In CRM Analytics, return the column date with the specified days or months added or removed.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Add or Subtract Days or Months

In CRM Analytics, return the column date with the specified days or months added or removed.

### Required Editions

## Add or Subtract Days or Months

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d72020e39">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d72020e39 ">To create a recipe:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d72020e39 ">Edit CRM Analytics Dataflows OR Edit Dataset Recipes</td>

          </tr>
        </tbody>
      </table>

1. In a Transform node of a Data Prep recipe, select one date column in the Preview tab.
2. Select the Formula button (![Formula button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/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-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_date_difference.png)
    
    1. Start Date Column is automatically filled with the date column you previously chose. Cancel and restart to choose a different Start Date.
    2. Choose **Days** or **Months** to add or subtract.
    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. Click **Apply** to add the transformation to the Transform node.
    
    The Preview tab shows the new calculated date column.
    
    ![Preview shows the new calculated date column.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_calculated_date_outcome.png)
7. To view the Graph area, click the Collapse button (![Collapse button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_button_collapse.png)).
8. Save the recipe.