To add DatePicker to a SpreadSheet cell in addition to your code you should add showButton
configuration to this cell.
shows how you could define custom date range by setting the start and the end date of a third DatePicker cell. In this case, cell B1 is setting the start date and D1 is setting the end date of C2 DatePicker cell.
Here comes the custom formula you've asked for. You can see the from
configuration of cell C2 in the provided example. It is defined using a formula that checks if there is a date picked in cell B2. If a date is not selected in B2, then the start date of C2 DatePicker is set to 1 January 2019.
So to answer your question, you can leave the dataType of the cell you want to use as DatePicker to "date" and write your custom formula in the form
You could also find useful this Custom cell editors demo
from our documentation.
Get quickly onboarded and successful
with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.