的 Range.NumberFormat 应该帮助你确定给定格/范围被格式化为日期。如果单元格/范围日期格式然后NumberFormat属性将包含格式字符串，即DD / MM / YYYY

The Range.NumberFormat should help you determine if a given cell/range is formatted to a date. If the cell/range is date formatted then the NumberFormat property will contain the format string, i.e. dd/mm/yyyy