Skip to Content
0

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

Jan 28, 2017 at 04:26 AM

38

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Jan 29, 2017 at 07:38 PM
0

use this.

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

Share
10 |10000 characters needed characters left characters exceeded