How to use FIRSTNONBLANK/LASTNONBLANK in a custom calendar
I have created a custom calendar.
I have mapped Week(List) and Year(List) corresponding to Time(Days).
I would like to create a module that sets the start and end dates to the Week(List) and Year(List).
I thought I could use the FIRSTNONBLANK and LASTNONBLANK function to get those dates, but it does not work.
Is there any good solution for this?