# Automatic subscription date calculation : every week, every 2 week, every month **URL:** \ **Category:** Ask for Help\ **Created:** [November 29, 2023, 3:01pm UTC](https://community.glideapps.com/t/automatic-subscription-date-calculation-every-week-every-2-week-every-month/68243 "2023-11-29T15:01:19Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Maud\_Nova](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maud_nova/32/54802_2.png) [@Maud\_Nova](https://community.glideapps.com/u/Maud_Nova)\ **Post date:** [November 29, 2023, 3:01pm UTC](https://community.glideapps.com/t/automatic-subscription-date-calculation-every-week-every-2-week-every-month/68243/1 "2023-11-29T15:01:19Z")
Dear Community, I am working on a delivering application. Our client choose a subscription for the delivering. The option are : Every week Every 2 weeks Every Month. When the day of delivering is today, I would like to see my clients on the first page. I don’t know the method to generate all the dateS of delivering (for the next 2 years) per client based on the first day of delivering. Thank you for your help ! ---
**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:** [November 29, 2023, 11:57pm UTC](https://community.glideapps.com/t/automatic-subscription-date-calculation-every-week-every-2-week-every-month/68243/2 "2023-11-29T23:57:04Z")
For weeks, I think it can work like this with Math columns: - Every week: D+7\*CEILING((N-D)/7) - Every 2 weeks: D+14\*CEILING((N-D)/14) With D being the date the subscription starts, N being the Now value. About month, how would you handle the cases like this: User starts subscription on January 30th but there’s no February 30th? ---
**Author:** ![Maud\_Nova](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maud_nova/32/54802_2.png) [@Maud\_Nova](https://community.glideapps.com/u/Maud_Nova)\ **Post date:** [November 30, 2023, 1:50pm UTC](https://community.glideapps.com/t/automatic-subscription-date-calculation-every-week-every-2-week-every-month/68243/3 "2023-11-30T13:50:57Z")
Thanks a lot for your answer. I also have the right formula with [https://www.youtube.com/watch?v=DkcLP9ZI6V4](https://www.youtube.com/watch?v=DkcLP9ZI6V4) (date calculation) I don’t know how to have 1 column with all the delivering days per clients from one table with all the date. [Date difference excluding weekends and bankholidays - #3 by Darren\_Murphy](https://community.glideapps.com/t/date-difference-excluding-weekends-and-bankholidays/55385/3) (calendar with bank holiday) ---
**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:** [November 30, 2023, 11:16pm UTC](https://community.glideapps.com/t/automatic-subscription-date-calculation-every-week-every-2-week-every-month/68243/4 "2023-11-30T23:16:49Z")
So what have you got so far? If you have columns ready, the last thing you need to add is an if-then-else column to return the date based on the subscription type, if I understand you right. Can you explain more about the bank holidays part? Do you want to integrate that as well? It would be much more difficult. ---
**Author:** ![Maud\_Nova](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maud_nova/32/54802_2.png) [@Maud\_Nova](https://community.glideapps.com/u/Maud_Nova)\ **Post date:** [December 1, 2023, 3:20pm UTC](https://community.glideapps.com/t/automatic-subscription-date-calculation-every-week-every-2-week-every-month/68243/5 "2023-12-01T15:20:43Z")
Dear ThinhDinh, thank you for your reply I think that with the video [Date difference excluding weekends and bankholidays - #3 by Darren\_Murphy](https://community.glideapps.com/t/date-difference-excluding-weekends-and-bankholidays/55385/3) here I may find my answer. I will let you know the solution when I find it. Working with dates, it is a challenge ! ---
**Author:** ![mattwensing](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattwensing/32/72905_2.png) [@mattwensing](https://community.glideapps.com/u/mattwensing)\ **Post date:** [March 31, 2024, 3:50pm UTC](https://community.glideapps.com/t/automatic-subscription-date-calculation-every-week-every-2-week-every-month/68243/6 "2024-03-31T15:50:55Z")
Did this end up solving it for you? Curious!