Formula error

Copper Contributor

What is wrong with this formula? =SUM(DATEVALUE(G2))-TODAY() it returns #VALUE ??

3 Replies


There is no need to use SUM here. The formula is equivalent to


What does G2 contain?

5/26/2024 @Hans Vogelaar 


If G2 is a real date, you shouldn't use DATEVALUE.

Does this work?


Format the cell with the formula as General.