# Excel formula Workdays

**URL:** <https://community.glideapps.com/t/excel-formula-workdays/43674>\
**Category:** Ask for Help\
**Created:** [June 29, 2022, 4:49pm UTC](https://community.glideapps.com/t/excel-formula-workdays/43674 "2022-06-29T16:49:58Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**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 1, 2022, 9:48pm UTC](https://community.glideapps.com/t/excel-formula-workdays/43674/4 "2022-07-01T21:48:32Z")

</div>

Hola @Alexey_Khrolovich

There are 2 tricks to get this (one is easier than the other):

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/4/543e93e5de4355d3c4e48cfe55e97b0694e200dc.png)

1. 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:  

2. 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 them manually (it’s the bad news 🥴). GS makes the life easier because Google has the _To\_Date()_ formula to convert that number to a date but unfortunately, the Excel plugin doesn’t include this one… don’t hate please!

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/2/9214d946685168e52224c523486c5736cb7d7b1d.png)

Saludos!

---

_[View the full topic](https://community.glideapps.com/t/excel-formula-workdays/43674)._