Formula for inserting date of last trading day

[kb9omaaj]

I'm trying to come up with a formula that allows me to insert the date of the previous trading day. Because for several reasons I can't create a column array of manually entered holidays, I'm trying to find a formula that would produce this. I've tried this, but excel doesn't like it.

=DATUM(JAHR(ARBEITSTAG(HEUTE();-1;{DATUM(Jahr(heute());01;01);DATUM(Jahr(HEUTE());12;25))})); MONAT(ARBEITSTAG(HEUTE();-1;{DATUM(Jahr(heute());01;01);DATUM(Jahr(HEUTE());12;25))})); TAG(ARBEITSTAG(HEUTE();-1);{DATUM(Jahr(heute());01;01);DATUM(Jahr(HEUTE());12;25))}))

Any help would be awesome

[kb9omaaj]

removed for double post

[kb9omaaj]

Sorry the formula is in German

Datum = Date
Arbeitstag = Workday
Heute = Today
Jahr = Year.
Monat = Month
Tag = Day

You can easily write to me in English, and any formulas I can convert into German.

[daddylonglegs]

If you are trying to build holidays in to the formula you can use a version like this

=WORKDAY(TODAY(),-1,DATE(YEAR(TODAY()),{1,12},{1,25}))

That would give the previous workday to today with 1st Jan and 25th December excluded. You can extend the excluded dates, e.g. to also exclude 5th August

=WORKDAY(TODAY(),-1,DATE(YEAR(TODAY()),{1,12,8},{1,25,5}))

[kb9omaaj]

excellent, thanks!

[kb9omaaj]

just one question, besides formatting the cell, how can I get that to show the date in date format and not as a serial number?

[martindwilson]

=TEXT(WORKDAY(TODAY(),-1,DATE(YEAR(TODAY()),{1,12,8},{1,25,5})),"dd mmm yyyy")