0

End of Month custom column (EOMONTH formula)

Is there way to convert dates to End of Month date using formula like EOMONTH. In our system, we do not load data for Sundays or Holidays and I would like to use the EOMONTH formula to convert any non-month end dates to month end date. 

 

1 reply

null
    • NPANS
    • 12 hrs ago
    • Reported - view

    Long winded, but doable without a built-in function:

    • get the year: y=year(<your date>)
    • get the month: m=month(<your date>)
    • create a date as the first of that month: c=CreateDate( y , m , 1)
    • add a month to that date: a=AddMonths( c , 1 )
    • deduct a day from that month: AddDays( a , -1 )

    in one calc:

    AddDays( AddMonths( CreateDate(year(<your date>), month(<your date>),1),1),-1)
Login to reply

Content aside

  • 12 hrs agoLast active
  • 1Replies
  • 6Views
  • 2 Following