# Hyperformula - WORKDAY.INTL

**URL:** https://community.glideapps.com/t/hyperformula-workday-intl/34196
**Category:** Ask for Help
**Created:** [November 8, 2021, 8:24am UTC](https://community.glideapps.com/t/hyperformula-workday-intl/34196 "2021-11-08T08:24:05Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![l3oy8231](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l3oy8231/32/32303_2.png) [@l3oy8231](https://community.glideapps.com/u/l3oy8231)
#### Post date: [November 8, 2021, 8:24am UTC](https://community.glideapps.com/t/hyperformula-workday-intl/34196/1 "2021-11-08T08:24:05Z")

</div>

I can’t use this formula to get results like in Excel.

Where did I go wrong?

 ![1636359588882](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/ddc4a4ae511aac01591468166ed3c6e51b9a01cd.jpeg)

![1636359918765](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/52096f822063d53fd2dbc5a714f2b1d79761ffd2.jpeg)

I want to find a working day that cuts off Saturday and Sunday. by starting on 2021-11-01 and set the date to work is 5 days

Thank you very much for helping me. 🙏 🙏 🙏

---

<div class="post-metadata">

### Author: ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)
#### Post date: [November 8, 2021, 11:08am UTC](https://community.glideapps.com/t/hyperformula-workday-intl/34196/2 "2021-11-08T11:08:52Z")

</div>

=2021-11-01 is not understood as a date, I’m guessing—I think it’s understood as an arithmetic expression that evaluates to 2009.

---

<div class="post-metadata">

### Author: ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)
#### Post date: [November 8, 2021, 12:18pm UTC](https://community.glideapps.com/t/hyperformula-workday-intl/34196/3 "2021-11-08T12:18:02Z")

</div>

Try changing A1 to =DATE(2021,11,01).

---

<div class="post-metadata">

### Author: ![l3oy8231](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l3oy8231/32/32303_2.png) [@l3oy8231](https://community.glideapps.com/u/l3oy8231)
#### Post date: [November 9, 2021, 3:43am UTC](https://community.glideapps.com/t/hyperformula-workday-intl/34196/4 "2021-11-09T03:43:34Z")

</div>

Is there any way that can be used Can I get date information from the date column? I tried the picture and it doesn’t show any results.

 ![Untitled-1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e32688d700e50030ac8c7ee44c24cd1972a4007a.jpeg)

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [November 9, 2021, 4:19am UTC](https://community.glideapps.com/t/hyperformula-workday-intl/34196/5 "2021-11-09T04:19:37Z")

</div>

What are you trying to get for a result? Maybe there is a better way instead of trying to use excel formulas.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 9, 2021, 4:29am UTC](https://community.glideapps.com/t/hyperformula-workday-intl/34196/6 "2021-11-09T04:29:51Z")

</div>

Are you just trying to identify which dates are weekdays (Mon-Fri)?

If that’s the case, you can do that with a combination of a Math and If-then-else column:

- Math column uses `Weekday(Date)`
- If-then-else:  
– If math column \< 2, then empty  
– Else if math column \> 6, then empty  
– Else `true`

 ![Screen Shot 2021-11-09 at 12.25.38 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aae251017390386d3cdcea348cabbfbb040c2b8d.png)

 ![Screen Shot 2021-11-09 at 12.28.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/49d31464d28afb463b2d369c63e9e4f23dae5038.png)

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [November 10, 2021, 4:30am UTC](https://community.glideapps.com/t/hyperformula-workday-intl/34196/7 "2021-11-10T04:30:29Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.