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…

Magic (or not) formula 😁

Ask for Help

Darren_Murphy July 8, 2022, 10:22am 2

1 Like

Topic		Replies	Views
Get the days of the current month Ask for Help	11	140	October 17, 2024
Calculating Number of days left to end the month Ask for Help	4	289	April 30, 2023
Calculating remaining days of month Ask for Help date-math	3	258	February 6, 2024
🆕 Plugins are live in the Editor! Project Showcase	22	1557	November 6, 2021
Days calculation Ask for Help	1	120	March 30, 2024

Magic (or not) formula 😁

Related topics