# 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:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexey\_Khrolovich](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_khrolovich/32/37980_2.png) [@Alexey\_Khrolovich](https://community.glideapps.com/u/Alexey_Khrolovich)\
**Post date:** [June 29, 2022, 4:49pm UTC](https://community.glideapps.com/t/excel-formula-workdays/43674/1 "2022-06-29T16:49:58Z")

</div>

Hello, i have column with date1 and column with number of working days.  
I need to calculate date2=date1+Nworking days  
So result date must be after N working days (business days).

There is excel formula for this  
WORKDAY(date;days)

i tried to to create column “excel formula” but workday formula not working there.

Please advice

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [July 1, 2022, 12:16pm UTC](https://community.glideapps.com/t/excel-formula-workdays/43674/3 "2022-07-01T12:16:21Z")

</div>

Are you using Google Sheets or Excel as Database of your project?

If this is a GSheets, try this: [WORKDAY: Google Sheets Formulae Explained](https://www.causal.app/formulae/workday-google-sheets)

---

<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!

---

<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 13, 2023, 11:32am UTC](https://community.glideapps.com/t/excel-formula-workdays/43674/5 "2023-07-13T11:32:49Z")

</div>

> [@gvalero](#):
>
> 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

I finally found the missing piece to get a complete solution. To convert Numbers generated by **WorkDay()** formula to Dates using Excel plugin the right way is to use **TEXT()** formula.

Something like this can help:  
` TEXT(A1,"MMM dd, yyyy")`

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/206ff8bcb4c1a6fc5f3d931aa33f05792e584e7d.png)

Saludos!