on 01-28-2017 4:26 AM
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
use this.
=If(MonthNumberOfYear([Date])=MonthNumberOfYear(CurrentDate())) Then CurrentDate() Else LastDayOfMonth([Date])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.