Hello to all, Here is the problem.
I have ‘End-Date’, I have ‘number of production days’ and I would like to calculate the ‘Start-date’ using these two variables. Looking for advice. Kindest regards.
Hi Alain and welcome to the infinity community!
I would use the Workday formula, but with a negative number of days for that, but that´s not possible yet. You better contact the chat support, they might know a working solution. If not, they will forward it to the dev team.
WORKDAY
Syntax: WORKDAY(start_date, num_days, [holidays])
Explanation: Calculates the end date after a specified number of working days.
Is there any way to accomplish this based on calendar days? So that weekends can be included too?
I actually just figured it out. You have to use WORKDAY.INTL and the 3rd optional entry, you can add 7 characters in between quotes (either 1 or 0 where 1 means exclude and 0 means include) that represent Monday through Sunday.
So my final formula looks something like WORKDAY.INTL(Date, Days, “0000000”)
1 Like