Anyone knows how I evaluate dates, as seen as below?

According to this list, https://www.techonthenet.com/excel/formulas/index_vba.php, all the functions in the formula should be valid.

CodePudding user response：

I'm not sure exactly why you want to use Evaluate, but the issue is the use of DateSerial. Evaluate should be used with worksheet formulas, not VBA functions.

The equivalent worksheet formula to DateSerial is Date.