number of days until the end of the current month

[DaGi07]

Hello guys,

I would like find an expression that give me the number of days until the end of the current month

Example (today 28 december, result--> 3 days to the end of december)

[dbaum]

EOMONTH(TODAY(), 0) - DAY(TODAY())

[Koichi_Tsuji · Accepted solution]

Need to wrap EOMONTH by DAY() as well.

DAY(EOMONTH(TODAY(), 0)) - DAY(TODAY())

[dbaum]

Thanks for the correction.

So, I probably overengineered the original draft expression. The following ought to suffice:

EOMONTH(TODAY(), 0) - TODAY()

[Koichi_Tsuji]

Date minu date is always returning DURATION in AppSheet.

So your original expression of DAY(EOMONTH(TODAY(), 0)) - DAY(TODAY()) 

is going to be the right and compact expression to achieve a goal here.

[dbaum]

Right--of course. Thanks for the additional correction!

So, my error wasn't overengineering, but rather replying too quickly--twice.

[Koichi_Tsuji]

😄