# 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:** 1\
**Showing post:** 3

<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 (…

---

_[View the full topic](https://community.glideapps.com/t/calculations-with-dates/77310)._
