I’m trying to make a column that shows the amount of days until the end of a month but I’m having some trouble. Does someone have a formula for this off the top of their head?
You can use the EndOfMonth and DateDiff formula to calculate this! Try using this formula:
DateDiff(“day”, [Date], EndOfMonth([Date]))