Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Oct 28, 2021

Add EOMONTH (end of month) calculation function

EOMONTH() is a common Excel function because in many cases, users (all Oil & Gas industry) need to compute information based off the end of the month.

Currently a typical user will not know how to compute the End of the Month using formulas because it is not trivial (like using an out of the box function; like in excel) and therefore google for help. Most suggested solutions on Google are not accurate because they do not work for dates in December. I have yet to find one that is accurate and works for dates in December but my formula that also works for December is also very large and scares users that simply use a function in Excel.

  • Attach files
  • Guest
    Reply
    |
    Oct 29, 2021

    Hi Hector,
    We developed a custom SDN that has many extra formulas available such as this.
    Works with leap years in Feb too.
    EOM(Date(2020,01,15),1) > 2/29/2020 (End of current month, +1)
    Offset is optional

    Another is Workday.
    See attached