Creating NEW date by skipping weekend & fixed holiday list

Question

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.

comparison.xlsx

Fixed Holiday List.xlsx

OllieClarke · Answer

@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

dateupdate.yxmd

joshikalyani · Answer

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

joshikalyani · Answer

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)