# Bill by usage

**URL:** <https://community.glideapps.com/t/bill-by-usage/20298>\
**Category:** Ask for Help\
**Created:** [December 25, 2020, 8:43pm UTC](https://community.glideapps.com/t/bill-by-usage/20298 "2020-12-25T20:43:53Z")\
**Posts on this page:** 4\
**Page:** 1

<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:** [December 25, 2020, 8:43pm UTC](https://community.glideapps.com/t/bill-by-usage/20298/1 "2020-12-25T20:43:53Z")

</div>

Does anyone have a creative way to bill by usage similar to the way _Glide_ charges for their Private Pro App “$2 dollars per user, per month, billed monthly”

In my situation I am using a spreadsheet formula, the basis of which is `=COUNTIFS(C:C;"=My_Item";A:A;">="&TODAY()-30)` to determine usage of a particular item over the last 30 days.

This is working as expected however it could be more precise (is just the last 30 days) and I only need the result on the 1st of the month…not updated everyday.

I know this would be possible with app script but was wondering if there is an elegant way to do this in sheets and or glide. 😀

---

<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:** [December 25, 2020, 10:49pm UTC](https://community.glideapps.com/t/bill-by-usage/20298/2 "2020-12-25T22:49:39Z")

</div>

Is there any disadvantage of having it updated everyday?

---

<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:** [December 25, 2020, 11:00pm UTC](https://community.glideapps.com/t/bill-by-usage/20298/3 "2020-12-25T23:00:33Z")

</div>

I’d like to bill once a month (for the prior month) while giving the user the first few days of a new month to complete payment.

I think I’m on the right path with the following formula where column A contains your dates.

```
=COUNTIFS(A:A,">="&EOMONTH(TODAY(),-2)+1,A:A,"<="&EOMONTH(TODAY(),-1)

```

A count of all the dates from the prior month…

Update: Adding some additional criteria to the syntax achieves my desired result.

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:58pm UTC](https://community.glideapps.com/t/bill-by-usage/20298/4 "2024-01-17T16:58:27Z")

</div>