Hi everyone, Can I find ( with formula ) days numbers within a month based on a given date ? For example, I have July, 8 2022 . How many days are in July ? How could be calculated ? Thank you, M.V.

Hola! Another trick (I think is simpler) is using the Excel plugin with DAY(EOMONTH({value},0)) [image] The first step is to convert the Glide date into a text value and using Format Date plugin is the key. [image] Later, use Excel plugin using this formula: DAY(EOMONTH({value},0)) and you ha…

[image] Fun with Dates Project Showcase Jean-Claude does not stop here hehe. Darren’s idea made me think about a formula to derive the current month’s number of days. [image] And here we go! Tested some timestamps. N+31-(FLOOR(DAY(N)/16))*15+1-DAY(N+31-(FLOOR(DAY(N)/1…

Thank You ! :love_you_gesture::guitar::beers:

Magic (or not) formula 😁

Ask for Help

Darren_Murphy July 8, 2022, 10:22am 2

Topic		Replies	Views
Get the days of the current month Ask for Help	10	214	October 10, 2024
Calculating Number of days left to end the month Ask for Help	3	318	April 29, 2023
Calculating remaining days of month Ask for Help date-math	2	284	January 30, 2024
🆕 Plugins are live in the Editor! Project Showcase	22	1698	November 6, 2021
Days calculation Ask for Help	1	132	March 30, 2024

Magic (or not) formula 😁

Related topics