Creating NEW date by skipping weekend & fixed holiday list

[joshikalyani]

Hi

I need to create new column where, it should be COB+1, when there is no Weekend(sat/sun)or not any date from fixed holiday list.

If there is any weekend or any holiday date from the fixed list then it should be skipped & next date should be shown.

Then comparing this COB+1 column with NEW DATE column.

[OllieClarke]

@joshikalyani 

Here's a way of doing this:

It requires changing your lookup a bit. I also generated the days in 2023 as your comparison file I don't think was correct.

Hope that helps,

Ollie

[joshikalyani]

Thank you for reply.

COB Date is fixed, where i've to create new Column which will be COB+1 only when there is no holidays or weekends, else create new date which will be after skipping all these dates(skiping holidaty list & weekend)

[joshikalyani]

e.g. As per the attached Comparison file COB date is 13-oct-2023 so COB+1 column should be populated with 16-Oct-2023.

Also in some cases if there is any Holiday from list then it should take next date

[OllieClarke]

@joshikalyani okay, I added the formula tool to create COB+1 before the join, then updated all references after that to use COB+1 rather then COB Date, but otherwise it's identical