End date that should be a working day only

Tin · 2024-03-19T13:50:36+00:00

There was an error rendering this rich post.

We want to get the End date but it should only fall on the weekday, 
we have tried other workarounds but it didn't work as intended. 

See screenshots fyr.

END DATE (working days only) = START DATE + Duration Days

we also have a module to count the weekends and holidays

so to get the END DATE (working days only)

END DATE (working days only) = START DATE + Duration Days + Weekend Count

If you have an idea or other workarounds, please comment below, that would be of big help.

Sincerely,

Tin

Accepted answers

All comments

JaredDolich

@Tin I think you're on the right track but its not entirely clear what you're trying to accomplish. You will always have an end date on a weekday if you set the calendar that way. Each model, however, can only have one day for the end of the week, e.g. Friday.

Or, are you trying to count up the workdays during a month?

Regardless of your use case, my suggestion would be to create a system module for your weekly calendar, whether its the default calendar or for the time range. In that system module create a set of line items that check if the end date falls on the weekend or the holiday. Use a simple conditional (IF/THEN) to recalculate the end date based on your finding. Looks like you have all the checks set up, so this should be simple.

If you're not getting the result you're looking for, can you articulate more clearly what constitutes success? Let's get you to the finish line!

Jared

Tin

We want to get the end date, when we add the duration days it should only count the working days. for example, the project started on

3/1/2024,

the end date should be (which is the 20th day of duration, starting the count from 3/4/2024)

3/29/2024.

as you can see in the first screenshot, the first 3 items are correct but the next items are incorrect.

Thank you.

JaredDolich

@Tin

Got it. There is no simple, one function, that will solve this use case. We have to create a lookup table that adds the weekend count to the duration in order to get the end date. Let's start with what we know.

First, we know the begin day and the duration. Based on that knowledge we can create this chart:

So, if you're determined to use a calendar for this, we'll need to create this lookup grid that adds or removes weekend dates based on the start date.

Let's test this. 1/8/2020 is a Wednesday. Lets create a 20 day project and a 24 day project. We get the right results.

Using you're example of 3/6/2024 and 20 days we get 4/2/2024 which is correct. For testing, I also tried 24 day project with 3/6/2024 and got the right answer.

You got this!

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…