# How to calculate how many months in certain days?

**URL:** <https://community.glideapps.com/t/how-to-calculate-how-many-months-in-certain-days/33385>\
**Category:** Ask for Help\
**Created:** [October 21, 2021, 7:41am UTC](https://community.glideapps.com/t/how-to-calculate-how-many-months-in-certain-days/33385 "2021-10-21T07:41:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [October 21, 2021, 7:41am UTC](https://community.glideapps.com/t/how-to-calculate-how-many-months-in-certain-days/33385/1 "2021-10-21T07:41:22Z")

</div>

Hello,

Let’s say from 1st Jan 2021 until today is 294 days.  
I have a price list for Machine A type rental is RM3,000/monthly.  
I have a column calculated from 1st Jan until today written 294 days.  
As you know 294 days is equal to 9 months, 21 days.  
I need the calculation will be like  
= (RM3,000 x 9months) + [(RM3,000/31days) x 21days]  
= (RM27,000) + [(RM3,000 / 30) x 21]  
= RM27,000 + RM2,100  
= RM29,100

---

<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:** [October 21, 2021, 7:46am UTC](https://community.glideapps.com/t/how-to-calculate-how-many-months-in-certain-days/33385/2 "2021-10-21T07:46:47Z")

</div>

> [@biha](#):
>
> I have a column calculated from 1st Jan until today written 294 days.  
> As you know 294 days is equal to 9 months, 21 days.

That’s true if your rental starts on Jan 1.  
But what if it doesn’t?  
What if it starts on Jan 15, or April 27, or Jun 13, or any other date?  
What would your calculation look like then?

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [October 21, 2021, 7:47am UTC](https://community.glideapps.com/t/how-to-calculate-how-many-months-in-certain-days/33385/3 "2021-10-21T07:47:41Z")

</div>

🤔

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [October 21, 2021, 7:51am UTC](https://community.glideapps.com/t/how-to-calculate-how-many-months-in-certain-days/33385/4 "2021-10-21T07:51:29Z")

</div>

Yes because again i need to calculate the utilization but in Dollar perspective.  
It was like RM3000 x 12 = RM36,000  
We have potential to have RM36,000 in a year for Machine A.  
Therefore, i have a number of days used as well.  
Need to convert to month first.  
What do you think?

---

<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:** [October 21, 2021, 7:56am UTC](https://community.glideapps.com/t/how-to-calculate-how-many-months-in-certain-days/33385/5 "2021-10-21T07:56:00Z")

</div>

I think it depends how you decide to define a month.  
Let’s say for example that a rental starts on Jan 15.  
You could do it two ways, either:

- the first full month is until Feb 15, and on the 15th of each month thereafter, or
- you do a pro-rata calculation until the end of Jan, and then full calendar months thereafter

I think the first option would probably be more common. But it’s up to you/your business to decide how to do it