Forum Discussion

AlanSulzer's avatar
AlanSulzer
Qrew Member
2 months ago

Match date to End of Month (EOM) date

I can't figure out how to do "=EOMONTH(A1,0)" like I can in Excel. Any ideas how to do this? The purpose is to bucketize all dates in a month across all months/years to a single date bucket for each ...
  • MarkShnier__You's avatar
    2 months ago

    I am not familiar with that Excel function, but there are two functions that probably will give you what you want.  

    FirstDayOfMonth([My Date Field])

    LastDayOfMonth([My Date Field])