Match date to End of Month (EOM) date

Question

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?

markshnier__you · Accepted Answer

I am not familiar with that Excel function, but there are two functions that probably will give you what you want.&nbsp;&nbsp;FirstDayOfMonth([My Date Field])LastDayOfMonth([My Date Field])&nbsp;

alansulzer · Answer

Thank you that was perfect. Solved!!

Forum Discussion

Match date to End of Month (EOM) date

2 Replies