# calculate a date in a workflow **URL:** \ **Category:** Sales Hub Tools\ **Tags:** workflows, sales\ **Created:** [August 16, 2021, 7:06am UTC](https://community.hubspot.com/t/calculate-a-date-in-a-workflow/42352 "2021-08-16T07:06:11Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![dmattauch](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dmattauch/32/102498_2.png) [@dmattauch](https://community.hubspot.com/u/dmattauch)\ **Post date:** [August 16, 2021, 7:06am UTC](https://community.hubspot.com/t/calculate-a-date-in-a-workflow/42352/1 "2021-08-16T07:06:11Z")
hi, So when my deal reaches closed won, i have a property “start date” and a property “end date” that i need filled. Start date is date of step so it’s easy to fill with workflow. End date is 60 days after start date. But in the workflow i can only select a static date or date of step. Is there any way to automatically fill end date or i have to put a task to do it? Many thanks David ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [August 16, 2021, 7:17am UTC](https://community.hubspot.com/t/calculate-a-date-in-a-workflow/42352/2 "2021-08-16T07:17:24Z")
Hi @dmattauch, There are a few ways to approach this. Out of the box, it’s not possible to set a date property to 60 days in the future. The first option would be to add a delay in the workflow and then set the property to the step of the date after this delay. Usually this doesn’t work because you need the date property to have a value before that. The second option would be [custom code actions in workflows](https://knowledge.hubspot.com/workflows/use-custom-code-actions-in-workflows) which allow you to calculate the date right in the moment, alternatively the new date formatting options. This would require HubSpot Operations Hub Professional, a recently introduced product. There is short LinkedIn video by @KyleJepson which demonstrates this: [https://www.linkedin.com/posts/kyleanthonyjepson\_hubspottipsandtricks-hubspot-automation-activity-6811624694639288320-blxp/](https://www.linkedin.com/posts/kyleanthonyjepson_hubspottipsandtricks-hubspot-automation-activity-6811624694639288320-blxp/) The third option would be a third-party solution, e.g. [Zapier](https://knowledge.hubspot.com/integrations/how-to-use-zapier-and-hubspot). With Zapier you could do the calculation outside of HubSpot and sync back the date information into HubSpot. Hope this helps! ---
**Author:** ![dmattauch](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dmattauch/32/102498_2.png) [@dmattauch](https://community.hubspot.com/u/dmattauch)\ **Post date:** [August 16, 2021, 7:19am UTC](https://community.hubspot.com/t/calculate-a-date-in-a-workflow/42352/3 "2021-08-16T07:19:45Z")
Perfect thanks Karsten ---
**Author:** ![NPW](https://avatars.discourse-cdn.com/v4/letter/n/bcef8e/32.png) [@NPW](https://community.hubspot.com/u/NPW)\ **Post date:** [February 1, 2023, 9:18pm UTC](https://community.hubspot.com/t/calculate-a-date-in-a-workflow/42352/4 "2023-02-01T21:18:48Z")
Hello All, If anyone is still searching for a workflow action to set a future date and/or specific date X days from Y, please upvote the following thread: [https://community.hubspot.com/t5/HubSpot-Ideas/More-workflow-options-for-date-properties/idc-p/750300#M134361](https://community.hubspot.com/t5/HubSpot-Ideas/More-workflow-options-for-date-properties/idc-p/750300#M134361) Thank you! ---
**Author:** ![AMammarella](https://avatars.discourse-cdn.com/v4/letter/a/977dab/32.png) [@AMammarella](https://community.hubspot.com/u/AMammarella)\ **Post date:** [September 6, 2023, 3:52pm UTC](https://community.hubspot.com/t/calculate-a-date-in-a-workflow/42352/5 "2023-09-06T15:52:16Z")
Hi everyone, since we had the common need to find a solution to this problem, we have published in the HubSpot marketplace “[Future Date Calculator](https://ecosystem.hubspot.com/marketplace/apps/productivity/workflow-automation/future-date-calculator-1828077)” app. The app adds a new deal-based workflow action that enables you to dynamically include a line item in an already existing deal. The Future Date Calculator app automatically populates a property with a future date based on another chosen date property. Furthermore, it calculates the number of days until the specified date, so all you need to do is enter the desired number of days. Try it and send us a feedback! We’re constantly working on new features for this app, every feedback would be very helpful. > **[HubSpot Marketplace](https://ecosystem.hubspot.com/marketplace/apps/productivity/workflow-automation/future-date-calculator-1828077)** Best, Alessio | | ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/f/5fc9c13afca70483dca274bd1dfd7a4e9cb014b2.jpeg) | ### Alessio Mammarella HubSpot SpecialistExelab | ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/6/e6e4eac4b326798ff384088f92d642884db49c47.png) | ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/6/36c779e0d19f292af3a2ce7493a6f0ac576dee5e.svg) | | | | | | | ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/9/7/97911b26f27a29c2d4d923efae01a15095d83b19.png) | | 333-6580788 | | | ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/c/6cc5dab148cb2c9d0051324b4a670d5aef67052b.png) | | [alessio.mammarella@exelab.com](mailto:mail@mail.it) | | | ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/3/b393d99d24043d8f715882739c05862a03edd1e3.png) | | [exelab.com](https://exelab.com/) | | | ---
**Author:** ![Franci](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/franci/32/225468_2.png) [@Franci](https://community.hubspot.com/u/Franci)\ **Post date:** [November 9, 2023, 7:58am UTC](https://community.hubspot.com/t/calculate-a-date-in-a-workflow/42352/6 "2023-11-09T07:58:26Z")
Hello 🙋🏼‍ If you have ever struggled with calculating future or past dates, say hello to the [Workflow Date Calculator](https://ecosystem.hubspot.com/marketplace/apps/productivity/workflow-automation/future-date-calculator-1828077) app we have released! Key Features: - Set Missing Days: Choose your start date, select your target property, and enter the desired number of days/weeks/months. - Compatibility: Works seamlessly with HubSpot’s standard objects—contacts, companies, tickets, and deals. Install the App: Head to the [HubSpot Marketplace](https://ecosystem.hubspot.com/marketplace/apps/productivity/workflow-automation/future-date-calculator-1828077), install the Workflow Date Calculator, and get started for free. Say goodbye to manual date calculations and hello to efficiency. Try the [Workflow Date Calculator](https://ecosystem.hubspot.com/marketplace/apps/productivity/workflow-automation/future-date-calculator-1828077) today and elevate your HubSpot workflow game! ---
**Author:** ![\_MMDL](https://avatars.discourse-cdn.com/v4/letter/_/b19c9b/32.png) [@\_MMDL](https://community.hubspot.com/u/_MMDL)\ **Post date:** [December 19, 2023, 8:43am UTC](https://community.hubspot.com/t/calculate-a-date-in-a-workflow/42352/7 "2023-12-19T08:43:04Z")
Your solution works perfectly, thanks! ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [February 26, 2024, 9:41am UTC](https://community.hubspot.com/t/calculate-a-date-in-a-workflow/42352/8 "2024-02-26T09:41:33Z")
Hi @dmattauch, Since my first reply, HubSpot expanded on the functionalities of calculation properties: [Create calculation and rollup properties](https://knowledge.hubspot.com/properties/create-calculation-properties) This can now be easily achieved with such a property, see this example that calculates a date 30 days after the record create date: ![karstenkoehler_0-1708940473944.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/7/7e400e8f919aaed186c2bfea3d59e47f936bf59b.png) The number of days is the first number in brackets. The rest of the numbers are there to calculate the amount of milliseconds as that’s the unit HubSpot uses here. If you want to calculate a date before, simply switch the + for a - sign. Best regards! ---
**Author:** ![fobin](https://avatars.discourse-cdn.com/v4/letter/f/c37758/32.png) [@fobin](https://community.hubspot.com/u/fobin)\ **Post date:** [February 26, 2024, 10:03am UTC](https://community.hubspot.com/t/calculate-a-date-in-a-workflow/42352/9 "2024-02-26T10:03:55Z")
This answer was right on time! Amazing how simple time calculation was now. 👍 ---
**Author:** ![YPirmohamed](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ypirmohamed/32/99594_2.png) [@YPirmohamed](https://community.hubspot.com/u/YPirmohamed)\ **Post date:** [February 25, 2025, 9:30pm UTC](https://community.hubspot.com/t/calculate-a-date-in-a-workflow/42352/10 "2025-02-25T21:30:34Z")
Hi @karstenkoehler, I’ve been trying to do this for 2 custom properties but unable to get it to give me an output. Ive attached a couple photos and even shown the revenue start date property that Im using as the base for the calculation. Let me know what I need to change. ![Screenshot 2025-02-25 at 21.28.05.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/8/86ed1a043f30080498513358a3640907d12ad320.png) ![Screenshot 2025-02-25 at 21.29.00.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/1/4/1441cca5230abd742916e3cecf94ea6d018653fe.png)