Solved
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 month through time?
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])
