I am trying to set an interactive grid column value (which is a date) based on the page items. I have tried different ways but unable to get it work in way it needs in my current project.

I have page items called P1_START_DATE (Start Date) and P1_NO_DAYS (No of Days). There is a normal button (say Set Dates) on an Interactive Grid region. On click of this button we need to generate the dates based on the values available in the P1_START_DATE and P1_NO_DAYS and populate the DATE column in an Interactive Grid.

If there is a weekend (Saturday or Sunday), then move forward in calculation.

For Example:

(Input)
P1_START_DATE: 15/09/2026 (or 17/09/2026)
P1_NO_DAYS: 3

(IG Expected Output 1)

DATE column:

15/09/2026

16/09/2026,

17/09/2026

(IG Expected Output 2)

Date column:

17/09/2026

18/09/2026

21/09/2026

Can anyone please help me? Your help and support would be grealy appreciated.

Using Oracle APEX v24.2 on Google Chrome.

Thanks!