I have loaded the Master Calendar. The data file loaded only indicates week ending dates which are each Friday.
In the attached example, I have a multi-box to select desired date/dates. My question is how to get the selection box to only indicate the Friday week ending dates rather than all dates.
Two possible solutions. The second is the better one:
If you want to stay with the Cookbook library routine, add a field to your Master Calendar that calculates the week ending date from the date in each row. Show this field on the sheet.
If not, create your own Master Calendar by determining first and last Fridays from your SQL SELECT result and creating a list by AUTOGENERATING rows and adding (RowNo()-1)*7 days to the starting Friday until you reach the last Friday.
There are lots of Master Calendar examples available for download and testing in the community.
Two possible solutions. The second is the better one:
If you want to stay with the Cookbook library routine, add a field to your Master Calendar that calculates the week ending date from the date in each row. Show this field on the sheet.
If not, create your own Master Calendar by determining first and last Fridays from your SQL SELECT result and creating a list by AUTOGENERATING rows and adding (RowNo()-1)*7 days to the starting Friday until you reach the last Friday.
There are lots of Master Calendar examples available for download and testing in the community.
