Calc Date Custom Format Formula Recognition?

[k8Bee]

I have a formula in a cell: =NETWORKDAYS($Formulas.A1,EOMONTH(A1,0),E2:E8)

This formula only works if I have the date formatted 08/13/2025 but I prefer to write my dates as 08-13-2025. Is there a way to get Calc to recognize 08-13-2025 as a valid date format and process the formula?

I’ve tried setting up user-defined formats to no avail, though if I use the date format 2025-08-13 it works. I have all my dates set up in TextExpander the way I prefer: 08-13-2025 so I’m not particularly keen to change those.

Does anyone have any suggestions to share? I’ve checked the wiki and documentation, but no solution was clear to me.

Thanks.

[EarnestAl]

@k8Bee

Is there a way to get Calc to recognize 08-13-2025 as a valid date format and process the formula?

If you are planning to share the spreadsheet, it is worth using one of commonly accepted patterns otherwise it might fail on a different computer. It is best to use ISO format YYYY-MM-DD if sharing internationally

[karolus]

Try to extend ⇒ Tools ⇒ Options ⇒ Languages and Locales ⇒ General ⇒⇒ Date Acceptance Patterns to sth like:

<existing patterns> ; D-; M-D ; M-D-Y 

ps. this is only relevant how calc interprets your input, … but complete independent how you may format the cells!