Javascript to calculate Work days

[gvalero]

Hola @Thais_Fontes

Months ago we had a similar case and this was my solution. Although it can be done via JS, I preferred to use a no code one (I read it twice and I don’t even believe it myself )

Excel formula Workdays

Hola @Alexey_Khrolovich There are 2 tricks to get this (one is easier than the other): [image] You must convert Glide date to a value using this format MM/dd/yyyy, you might use the Format Date plugin to achieve this quickly: [image] Later, configure Excel formula plugin using a new date column. You will get a number and not a real date value due to Workday() formula in GS works in this way. [image] Each value shown is the number of days since Dec 30, 1899 so, you have to convert…

Feliz día!