# Javascript to calculate Work days **URL:** \ **Category:** Ask for Help\ **Created:** [July 12, 2023, 10:21pm UTC](https://community.glideapps.com/t/javascript-to-calculate-work-days/63838 "2023-07-12T22:21:27Z")\ **Posts on this page:** 1\ **Showing post:** 5
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [July 13, 2023, 11:40am UTC](https://community.glideapps.com/t/javascript-to-calculate-work-days/63838/5 "2023-07-13T11:40:41Z")
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](https://community.glideapps.com/t/excel-formula-workdays/43674/4): > > 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: 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. Each value shown is the number of days since Dec 30, 1899 so, you have to convert… Feliz día! --- _[View the full topic](https://community.glideapps.com/t/javascript-to-calculate-work-days/63838)._