# Excel formula | DatedIf to work out days since upload

**URL:** <https://community.glideapps.com/t/excel-formula-datedif-to-work-out-days-since-upload/63016>\
**Category:** Ask for Help\
**Created:** [June 21, 2023, 4:14pm UTC](https://community.glideapps.com/t/excel-formula-datedif-to-work-out-days-since-upload/63016 "2023-06-21T16:14:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gary\_Willmott](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_willmott/32/837_2.png) [@Gary\_Willmott](https://community.glideapps.com/u/Gary_Willmott)\
**Post date:** [June 21, 2023, 4:14pm UTC](https://community.glideapps.com/t/excel-formula-datedif-to-work-out-days-since-upload/63016/1 "2023-06-21T16:14:45Z")

</div>

I am trying to calculate days since upload using the “Excel Formula”  
Using the [DatedIf Formula](https://www.statology.org/google-sheets-days-between-date-and-today/)

I have tried the following, but not getting a result? Can anyone suggest where I am going wrong?

 ![Screenshot 2023-06-21 at 18.11.14](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/a/bac81c5d062f2858ad37dc297447d70cfd25e875.png)

Can anyone suggest where I am going wrong?

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [June 21, 2023, 4:25pm UTC](https://community.glideapps.com/t/excel-formula-datedif-to-work-out-days-since-upload/63016/2 "2023-06-21T16:25:46Z")

</div>

I think it’s a good use case for the Date Difference column.

 ![Screen Shot 2023-06-21 at 12.24.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/ab95f499e82bc6eb99f0ba8187ccef711c390d32.png)

---

<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:** [June 21, 2023, 4:25pm UTC](https://community.glideapps.com/t/excel-formula-datedif-to-work-out-days-since-upload/63016/3 "2023-06-21T16:25:54Z")

</div>

There is a much simpler way to do this. Use a Math column.

```auto
Trunc(Now - Date)

```

---

<div class="post-metadata">

**Author:** ![Gary\_Willmott](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_willmott/32/837_2.png) [@Gary\_Willmott](https://community.glideapps.com/u/Gary_Willmott)\
**Post date:** [June 22, 2023, 9:41am UTC](https://community.glideapps.com/t/excel-formula-datedif-to-work-out-days-since-upload/63016/4 "2023-06-22T09:41:55Z")

</div>

Thanks Darren, this worked the best …

---

<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:** [June 23, 2023, 9:42am UTC](https://community.glideapps.com/t/excel-formula-datedif-to-work-out-days-since-upload/63016/5 "2023-06-23T09:42:35Z")

</div>

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