I cannot see the date range option for a custom date ticket field in Explore. Can I add a custom date range option in custom date field attributes?
No. The Edit date ranges option is only available on the default (built-in) date attributes.
For more information about date ranges for queries, see the article: Editing dates and date ranges.