cancel
Showing results for 
Search instead for 
Did you mean: 

End of month function: same as Excel EOMONTH function

Please can we have this function?

It is very useful for calculating end of periods.

Status: New
Comments
Level: Powered On

I found this work around, calculating current month's last day:

DateAdd(
    DateAdd(
        Date(Year(Today()), Month(Today()), 1),
        1,
        Months),
    -1,
    Days)

https://powerusers.microsoft.com/t5/General-Discussion/Set-Default-date-of-Date-Picker-to-first-and-...