'How to use Evaluate for dates?

How do I evaluate dates, as seen as below?

enter image description here

enter image description here

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

excelvba


Solution 1:[1]

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.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 BigBen

Related Questions

Reading Excel file with Selenium WebDriver C# and web form with values

How to update an existing row or table of an existing xlsx file using pyexcel for python

Equivalent C# Function For Excels Norm.S.Inv Function

I keep assigning a value to my variable but it stays empty

Excel RTD (Real Time Data) client other than Excel?

Create table from data on a worksheet with specific name and add column

Is it possible to use 'Microsoft.ACE.OLEDB.12.0' provider without installation?

Using VBA to query a SQL Server table in Excel

How to stop scroll bar auto jump in vba

If IsEmpty then go to column A but in same row and extract that data

How can I use a for each loop on an array?

VBA - worksheet object is hidden

Outlook 2010 GAL with Excel VBA

how to read a value from Column Name in Excel in Java

Replace cell value with image