Imitate workdays formula in excel to postgres

See more:

PostgreSQL

pSQL

Hi I am a postgres newbie,


Is there a way to get/predict the date of deadline using date posted and add just 20 days but must remove saturday and sunday in postgres.

Example:
posted date: 09-01-2022
deadline: ?

What I have tried:

Please correct:

with daysdt as (
select dd, extract(DOW from dd) dw
from generate_series('2022-08-01'::date , '2022-08-31'::date, '1 day'::interval) dd
)
select dd::date,dd::date + 20 from daysdt where dw not in (6,0)

For 08/01/2022 it returns 08/21/2022 instead of 08/26/2022,
please help me, it should remove saturday and sunday then add 20 days after to get the deadline date, thanks