Challenge #461: Accounting Payment Calendar

[ntakeda]

My solution.

Spoiler

 

[brandon_bunney]

these payments and days are accounted

[myastarling]

Here's my solution!

[fdavy]

Here's my solution !

[Jeffreyx]

Spoiler

[dillon_bok]

Spoiler

Fun challenge (used formulas instead of tools and learned a few things)

[Christina_H]

My solution

Spoiler

[arihant_jain]

Initially there are 2 columns to work with.

Step1: Using Append/ Find & Replace, append the holidays to calendar date.

Step2: Remove all the holidays from calendar using filter

Step3: Parse the incoming string to Date and use "DateTimeFormat" function to add Weekday and Month to the Calendar.

Step4: Filter out Saturdays and Sundays

Step5: Use the multi-row function to create the Work-day using if-else statement

Step6: Use the filter to find out the 6th day.

[TobiasFitschen]

Spoiler

 

[JBevan89]

Spoiler

The beauty is that there are so many different ways to do.