Magic (or not) formula 😁

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.

1 Like

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.

Later, use Excel plugin using this formula: DAY(EOMONTH({value},0)) and you have what you look for
image

Saludos!

1 Like

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

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.