Hello I have a google sheet that automatically gets populated from a jotform form. I would like to add 5 working days to the submision date of the form. I am strugling to find a way to do it Any help will be greatly appreciated.

Welcome to the Make community! You can use the built-in function addDays. For further assistance, please provide the following: 1. Screenshots of module fields and filters Please share screenshots of relevant module fields and filters in question? It would really help other community members to s…

Thanks Samliew I do not have a scenario that is working. I just have a trigger setup to monitor new rows into a google sheet I want to then process the info from one of the cells in the new row which is a date. You can use the built-in function addDays This will not work as I would like to add b…

Something like this perhaps? [Screenshot_2024-07-01_190724] (assuming the date is in column C) samliew – request private consultation Join the Make Fans Discord server to chat with other makers!

Thanks again It is my understanding that the addDays (42.date ; 5) will add 5 days to the date So if the initial date falls on a friday, the solution will add 5 days to friday, which will mean the date will change to the following week wednesday. That is only three business days. The solution …

Ah, so you meant add 7 days. Just add 7 days, it will include 5 working days. It’s a simple as that. No point complicating everything. samliew – request private consultation Join the Make Fans Discord server to chat with other makers!

Nice work just using a formula in GSheets! If you needed to do this within Make for any other reasons, there are at least two options, found here and here (both happen to be in the same thread). To summarize yet another slightly different approach: You get a starting date Using a repeater, you c…

Thanks Donald Much appreciated I did not think of trying it your way. A bit difficult for me to follow. Still new to Make.com Will keep it in mind for future reference. I am however having a problem when trying to run a complete scenario. Th update row works when running the module individuall…

Please see this BusinessDaysDate.json (9.1 KB) for a demo.

Add working days to a date field to get a due date

Questions

John_Doe July 1, 2024, 1:59pm 7

I managed to get it to work using the Workday function

I was not overcomplicating.

It needed to be different for different due dates.

cant just add 2 extra days, as it does not work for 3 days as I described

2 Likes

Topic		Replies	Views
How to calculate n-th day of week in month (and other spreadsheet date functions) Questions functions , date-time-functions	8	2266	September 7, 2023
Format date and time for workdays Questions functions	5	103	April 8, 2025
Get a Date from google sheets and do an automation if that date is a week old Questions filters , google-sheets , zoho	4	101	June 24, 2025
Add two business days set the due date Questions	6	2417	September 7, 2023
Removing Weekend Days between 2 dates Questions date-time-functions	7	1497	November 14, 2023

Add working days to a date field to get a due date

Related topics