alternative to workday ?

AppSheet AppSheet Q&A
1

Hello, in the appsheet we have the business day which is from Monday to Friday, what would be the option to generate installments from Monday to Saturday?

2 Likes
2

Hello! In AppSheet, if you’re currently generating installments only for business days (Monday to Friday) and you want to include Saturday as part of the schedule (i.e., Monday to Saturday), you need to adjust how you’re calculating the installment dates.

Here are your options depending on how you’re currently generating installments:

:white_check_mark: Option 1: Custom Expression for Next Installment Date (Include Monday to Saturday)

If you’re using a formula like this (for business days):

WORKDAY([Start Date], [Installment Number] - 1)

This excludes weekends (Saturday and Sunday). So, to include Saturday, you’ll need to manually build a weekday-based logic, since AppSheet doesn’t have a built-in function for “Monday to Saturday”.

:white_check_mark: Option 2: Custom Weekday Calculation (Monday to Saturday Only)

You can create a custom expression in a virtual column or action like this:

IFS(

WEEKDAY([Date]) = 7, [Date] + 2, – If Sunday (7), skip to Monday

TRUE, [Date] + 1 – Else, just add 1 day

)

To generate multiple installments skipping only Sundays, you’ll need to loop or simulate logic to add N weekdays where only Sunday is skipped.

If you want to create a list of installment dates, here’s a sample approach:

:counterclockwise_arrows_button: Option 3: Using a Scheduled Bot or Action to Generate Installments

  1. Have a start date (e.g. [Start Date])

  2. Create a bot or grouped action that:

Loops through N number of installments

Adds 1 day each time

Skips only Sundays (WEEKDAY([Date]) <> 7)

:blue_book: Alternative: Use Google Apps Script

If installment generation is too complex in AppSheet alone, you can use a Google Apps Script behind the scenes to:

Generate future dates

Exclude only Sundays

Push them back into the Installments table via API or sheet sync

:white_check_mark: Simple Expression for Next Installment (Skipping Sundays Only)

If you just want the next date skipping only Sundays:

IF(WEEKDAY([Previous Date] + 1) = 7, [Previous Date] + 2, [Previous Date] + 1)

3

hi @DEVIMPLOY_Autom

WORKDAY() in AppSheet excludes weekends (Saturday and Sunday) — there’s no built-in function to count Monday through Saturday only

to include Saturday as a business day, you’ll need to create a custom expression

example using WORKDAY() logic with adjustment:

  1. create a virtual column or expression like this:
    IF(
    WEEKDAY([Start Date]) = 7,
    [Start Date] + [Installments] + 1,
    [Start Date] + [Installments]
    )

    or, for more control, create your own list of dates and filter by WEEKDAY() <= 6 (Mon–Sat), then pick the nth date as the due date

1 Like