Skip to Content
avatar image
Former Member

Display of data for current month along with all month end in column

Hi Folks,

I need to display data for all month end along with current date data in a single column

OCT-31-2016
NOV-30-2016
DEC-31-2016
JAN-27-2017 (considering data available for current day date)

I was able to display for month end using lastdayofmonth function but this will not allow me to display for current month JAN-27-2017 which will display as JAN-31-2017

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 29, 2017 at 07:38 PM

    use this.

    =If(MonthNumberOfYear([Date])=MonthNumberOfYear(CurrentDate())) Then CurrentDate() Else LastDayOfMonth([Date])

    Add comment
    10|10000 characters needed characters exceeded