# How to compare two distinct types of columns

**URL:** <https://community.glideapps.com/t/how-to-compare-two-distinct-types-of-columns/76465>\
**Category:** Ask for Help\
**Created:** [September 18, 2024, 5:41am UTC](https://community.glideapps.com/t/how-to-compare-two-distinct-types-of-columns/76465 "2024-09-18T05:41:10Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 26, 2024, 12:16am UTC](https://community.glideapps.com/t/how-to-compare-two-distinct-types-of-columns/76465/5 "2024-09-26T00:16:04Z")

</div>

So circling back to your original post, you have a start date for everybody, and now you just need to calculate the dates where next steps start?

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

> [@Glide Editor screen goes blank when using Math Column](https://community.glideapps.com/t/glide-editor-screen-goes-blank-when-using-math-column/19646/15):
>
> Edit: I have some updates to this formula that I’ve explained in the post below. You’re requirement to back Feb 29th by a day if it’s not a leap year does complicate it a bit, but that’s not a problem. It just makes for a formula that’s much larger. Here is the formula if we were to allow Feb 29th to roll over to Mar 1st. ((Now-DAY(Now)+15)+(Years\*365.25)) - DAY((Now-DAY(Now)+15)+(Years\*365.25)) + DAY(Now) ‎ ‎ ‎ ‎ ‎ To get the leap year date of Feb 29th to back date to Feb …

Adapting this formula from @Jeff_Hager .

```auto
((Now-DAY(Now)+15)+(Years*365.25))
-
DAY((Now-DAY(Now)+15)+(Years*365.25))
+
DAY(Now)

```

With Now being the Start Date, Years being:

1 for Step 2  
2 for Step 3  
2.5 for Step 4  
3 for Step 5

---

_[View the full topic](https://community.glideapps.com/t/how-to-compare-two-distinct-types-of-columns/76465)._
