# Calculations with dates

**URL:** <https://community.glideapps.com/t/calculations-with-dates/77310>\
**Category:** Ask for Help\
**Created:** [October 24, 2024, 6:03pm UTC](https://community.glideapps.com/t/calculations-with-dates/77310 "2024-10-24T18:03:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![theweedyburton](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/theweedyburton/32/81109_2.png) [@theweedyburton](https://community.glideapps.com/u/theweedyburton)\
**Post date:** [October 24, 2024, 6:03pm UTC](https://community.glideapps.com/t/calculations-with-dates/77310/1 "2024-10-24T18:03:44Z")

</div>

Hi there, I have an issue that I am not getting right.

I have this: (for example)  
Start date → 2020/06/08  
End date → 2022/06/08  
I managed to calculate the term is 24 months, now I need to calculate 24 months from a specific date in another field.  
Say → 2020/08/05

Can anyone please help.

Much thanks  
Dx

---

<div class="post-metadata">

**Author:** ![micheal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/micheal/32/80181_2.png) [@micheal](https://community.glideapps.com/u/micheal)\
**Post date:** [October 24, 2024, 6:19pm UTC](https://community.glideapps.com/t/calculations-with-dates/77310/2 "2024-10-24T18:19:31Z")

</div>

Are you trying to count 24 months from that new start date?

---

<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:** [October 24, 2024, 6:53pm UTC](https://community.glideapps.com/t/calculations-with-dates/77310/3 "2024-10-24T18:53:22Z")

</div>

How would you handle leap years? For example, if the date is Feb 29th, what would you expect after 24 months when you have a February with only 28 days?

Refer to the two ‘Add m Months’ formulas in the following post. The formula you use depends on your answer to the above question.

> [@date Guide: Mastering Dates & Times](https://community.glideapps.com/t/guide-mastering-dates-times/70381):
>
> The Date & Time column contains both a date and time value within one single value. Dates and times can therefore be tricky to understand and to work with. It helps to keep things simple to stay out of trouble. Here are a few tips: Writing dates Avoid writing dates manually. Use a picker instead. If done via import, be weary of the format of the date column in the source. Relations Anytime you create a relation with a date, convert the date to either a string (template column) or a number (…

---

<div class="post-metadata">

**Author:** ![theweedyburton](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/theweedyburton/32/81109_2.png) [@theweedyburton](https://community.glideapps.com/u/theweedyburton)\
**Post date:** [October 24, 2024, 7:51pm UTC](https://community.glideapps.com/t/calculations-with-dates/77310/4 "2024-10-24T19:51:39Z")

</div>

Yes.
