Question: what is the difference between value and value2 in vba?
Answer: The VBA Date data type stores numbers as decimal. The only time it makes sense to use . Value instead of . Value2 is if you want to detect a date in a cell using the VBA.